DW_REQUISITION_CF

Requisitions Fact

Details

Module: Purchasing

Key Columns

REQUISITION_DISTRIBUTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
REQUISITION_DISTRIBUTION_ID NUMBER 38 0 True Requisition distribution unique identifier
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Source record identifier
REQUISITION_DISTRIBUTION_NUMBER NUMBER Requisition distribution number
REQUISITION_LINE_ID NUMBER 38 0 Requisition line unique identifier
REQUISITION_LINE_NUMBER NUMBER Requisition line number
REQUISITION_HEADER_ID NUMBER 38 0 Requisition unique identifier
REQUISITION_NUMBER VARCHAR2 64 Requisition number
DISTRIBUTION_CREATION_TIMESTAMP TIMESTAMP Indicates the date and time of creation of the row.
DISTRIBUTION_CREATION_DATE DATE Indicates the date of creation of the row.
DISTRIBUTION_LAST_UPDATE_DATE DATE Indicates the date of last update of the row.
DISTRIBUTION_CREATED_BY VARCHAR2 128 Indicates the user who created the row. DW_USER_D USERNAME
DISTRIBUTION_LAST_UPDATED_BY VARCHAR2 128 Indicates the user who last updated the row. DW_USER_D USERNAME
CODE_COMBINATION_ID NUMBER 38 0 Unique identifier for the general ledger charge account DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
DISTRIBUTION_QUANTITY NUMBER Requisition distribution quantity
PUOM_DISTRIBUTION_QUANTITY NUMBER Quantity for the distribution in Primary Unit of Measure
DISTRIBUTION_AMOUNT NUMBER Requisition distribution amount in functional currency
RECOVERABLE_TAX NUMBER Recoverable tax amount in functional currency
NONRECOVERABLE_TAX NUMBER Nonrecoverable tax amount in functional currency
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_CURRENCY_EXCH_RATE NUMBER Global currency conversion rate.
GLOBAL_DISTRIBUTION_AMOUNT NUMBER Requisition distribution amount in global currency
GLOBAL_RECOVERABLE_TAX NUMBER Recoverable tax amount in global currency
GLOBAL_NONRECOVERABLE_TAX NUMBER Nonrecoverable tax amount in global currency
PROJECT_ID NUMBER 38 0 Identifier of the project used to biuld the transaction descriptive flexfield for project-related transaction distributions DW_PJF_PROJECTS_ALL_D_TL PROJECT_ID
TASK_ID NUMBER 38 0 Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions DW_PJF_PROJ_ELEMENTS_D_TL PROJ_ELEMENT_ID, PROJECT_ID
EXPENDITURE_TYPE_ID NUMBER 38 0 Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions DW_PJF_EXP_TYPES_D_TL EXPENDITURE_TYPE_ID
EXPENDITURE_ORGANIZATION_ID NUMBER 38 0 Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. DW_INTERNAL_ORG_D ORGANIZATION_ID
EXPENDITURE_ITEM_DATE DATE Date on which project-related transaction is incurred
ITEM_SOURCE VARCHAR2 64 Indicates whether item comes from Catalog, Noncatalog, Quick Entry, Punchout, Req import or Req service. DW_POR_ITEM_SOURCE_D_TL CODE
LINE_TYPE_ID NUMBER 38 0 Requisition line type unique identifier DW_PURCHASING_LINE_TYPE_D LINE_TYPE_ID
REQUESTER_ID NUMBER 38 0 Requisition requester unique identifier DW_PERSON_NAME_CURRENT_D PERSON_ID
NON_CATALOG_FLAG VARCHAR2 32 Indicates whether item source is Non Catalog or not DW_Y_N_D_TL CODE
URGENT_FLAG VARCHAR2 32 Indicates whether the requisition requires urgent processing or not. Values will be Y or N. DW_Y_N_D_TL CODE
MODIFIED_BY_BUYER_FLAG VARCHAR2 32 Indicates whether a buyer modified this line or not. Values will be Y or N. DW_Y_N_D_TL CODE
BUYER_PROCESSING_FLAG VARCHAR2 32 Indicates if a buyer is currently processing this requisition line. Values will be Y or N. DW_Y_N_D_TL CODE
NEW_SUPPLIER_FLAG VARCHAR2 32 Indicator that this is a new supplier. Values will be Y or N. DW_Y_N_D_TL CODE
REQUISITION_LINE_STATUS VARCHAR2 64 Status of the requisition line. Values are APPROVED, CANCELED, REJECTED, WITHDRAWN, SPLIT, REPLACED etc. DW_POR_LINE_STATUS_D_TL CODE
BACK_TO_BACK_FLAG VARCHAR2 32 Indicates whether a requisition line has a backing sales order that is fulfilled using a back to back order. Y indicates a back to back requisition line. N indicates that the requisition line is not a back to back requisition line. DW_Y_N_D_TL CODE
UOM_CODE VARCHAR2 32 Unit of measure code DW_UNIT_OF_MEASURE_D_TL UOM_CODE
PUOM_CODE VARCHAR2 32 Abbreviated Primary Unit of measure DW_UNIT_OF_MEASURE_D_TL UOM_CODE
PUOM_CONVERSION_FACTOR NUMBER Conversion factor by which the UOM is equivalent to the primary UOM of the item.
LINE_QUANTITY NUMBER Quantity ordered
PUOM_LINE_QUANTITY NUMBER Line Quantity ordered in Primary Unit of Measure
LINE_CURRENCY_CODE VARCHAR2 32 Unique identifier for the currency on req line DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
UNIT_PRICE NUMBER Unit price in functional currency
LINE_CURRENCY_UNIT_PRICE NUMBER Unit price in req line currency
LINE_AMOUNT NUMBER Requisition line amount in functional currency
LINE_CURRENCY_AMOUNT NUMBER Amount on the req line in line currency
GLOBAL_UNIT_PRICE NUMBER Unit price in global currency
GLOBAL_LINE_AMOUNT NUMBER Requisition line amount in global currency
SUGGESTED_BUYER_ID NUMBER 38 0 Suggested buyer unique identifier DW_PERSON_NAME_CURRENT_D PERSON_ID
ASSIGNED_BUYER_ID NUMBER 38 0 Assigned buyer unique identifier DW_PERSON_NAME_CURRENT_D PERSON_ID
SUGGESTED_VENDOR_NAME VARCHAR2 512 Suggested supplier name
SUGGESTED_VENDOR_SITE VARCHAR2 256 Suggested supplier site name
SUGGESTED_VENDOR_CONTACT VARCHAR2 128 Suggested supplier contact name
SUGGESTED_VENDOR_EMAIL VARCHAR2 999 Suggested supplier email contact information
SUGGESTED_VENDOR_FAX VARCHAR2 32 Suggested supplier contact fax number
SUGGESTED_VENDOR_PHONE VARCHAR2 32 Suggested supplier phone number
VENDOR_ID NUMBER 38 0 Supplier unique identifier DW_PARTY_D SUPPLIER_ID
VENDOR_SITE_ID NUMBER 38 0 Supplier site unique identifier DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
ITEM_ID NUMBER 38 0 Item unique identifier. Inventory org will be DESTINATION_ORGANIZATION_ID DW_INVENTORY_ITEM_D INVENTORY_ITEM_ID ,ORGANIZATION_ID
ITEM_DESCRIPTION VARCHAR2 256 Item description
SUGGESTED_SUPPLIER_ITEM_NUMBER VARCHAR2 512 Suggested supplier product number
CATEGORY_ID NUMBER 38 0 Item category unique identifier DW_ITEM_CATEGORIES_D CATEGORY_ID
LINE_LAST_APPROVAL_DATE DATE Date when the requisition lines is last approved. It is used to compute the average approval time metric for the items on requisition lines.
LINE_LAST_SUBMITTED_DATE DATE Date when the requisition line is last submitted for approval. It is used to compute the average approval time metric for the items on requisition lines.
NEED_BY_DATE DATE Date the requisition is needed internally
LINE_CREATED_BY VARCHAR2 128 Indicates the user who created requisition line DW_USER_D USERNAME
LINE_LAST_UPDATE_DATE DATE Indicates the date of last update of requisition line
LINE_CREATION_DATE VARCHAR2 128 Indicates the date of creation of requisition line
LINE_LAST_UPDATED_BY VARCHAR2 128 Indicates the user who last updated requisition line DW_USER_D USERNAME
PO_HEADER_ID NUMBER 38 0 Purchase order header unique identifier
PO_NUMBER VARCHAR2 32 Purchase order number
PO_DESCRIPTION VARCHAR2 256 Purchase Order descriptive comments
PO_CREATION_DATE DATE Indicates the date of creation of purchase order
PO_PROC_BU_ID NUMBER 38 0 Procurement business unit identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
REQ_PROC_BU_ID NUMBER 38 0 Procurement business unit identifier in requisition document. In requisitions, procurement BU is stamped from purchase agreement when requisition line is created or bsed on assignment rules for emergency requisitions (auto create PO scenario). DW_INTERNAL_ORG_D ORGANIZATION_ID
SECURITY_PROC_BU_ID NUMBER 38 0 If REQ_PROC_BU_ID is null then PO_PROC_BU_ID else REQ_PROC_BU_ID DW_INTERNAL_ORG_D ORGANIZATION_ID
PO_LINE_ID NUMBER 38 0 Purchase order line unique identifier
PO_LINE_NUMBER NUMBER Purchase order line number
PO_LINE_TYPE_ID NUMBER 38 0 Purchase order line type unique identifier DW_PURCHASING_LINE_TYPE_D LINE_TYPE_ID
PO_LINE_CREATION_DATE DATE Indicates the date of creation of purchsae order line
PO_LINE_CLOSE_DATE DATE Indicates the date when purchase order line is closed
PO_DOCUMENT_STATUS VARCHAR2 32 Purchase order status. Values are CLOSED FOR INVOICING, OPEN, CLOSED FOR RECEIVING etc DW_DOCUMENT_STATUS_D_TL CODE
PO_LINE_STATUS VARCHAR2 32 Purchase order line status. Values could be CLOSED FOR INVOICING, OPEN, CLOSED FOR RECEIVING etc DW_PO_LINE_STATUS_D_TL CODE
SOURCE_ORGANIZATION_ID NUMBER 38 0 Inventory organization which will supply the item to the destination inventory organization in an internal material transfer operation. DW_INTERNAL_ORG_D ORGANIZATION_ID
SOURCE_SUBINVENTORY VARCHAR2 64 Subinventory within a source inventory organization which will supply the item to the destination inventory organization in an internal material transfer operation. Inventory org will be DESTINATION_ORGANIZATION_ID DW_INV_SUBINVENTORY_D SECONDARY_INVENTORY_NAME,ORGANIZATION_ID
SOURCE_TYPE_CODE VARCHAR2 64 Indicator of the type of the source of supply for the requisition line. The possible values are INTERNAL for inventory organizations and EXTERNAL for suppliers. DW_POR_SOURCE_TYPE_D_TL CODE
DESTINATION_ORGANIZATION_ID NUMBER 38 0 Destination organization unique identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
DESTINATION_SUBINVENTORY VARCHAR2 64 Destination subinventory name. Inventory org will be DESTINATION_ORGANIZATION_ID DW_INV_SUBINVENTORY_D SECONDARY_INVENTORY_NAME,ORGANIZATION_ID
DESTINATION_TYPE_CODE VARCHAR2 64 Destination type code. Values could be EXPENSE, INVENTORY, MANUFACTURING, DROP SHIP etc DW_POR_DESTINATION_TYPE_D_TL CODE
ONE_TIME_LOCATION_FLAG VARCHAR2 32 Indicates that the deliver to location of the requisition line is a one-time location. Values are Y or N. DW_Y_N_D_TL CODE
DELIVER_TO_LOCATION_ID NUMBER 38 0 Deliver-to location unique identifier DW_WORKER_LOCATION_D LOCATION_ID
DELIVER_TO_CUST_ID NUMBER 38 0 Customer to whom merchandise is being delivered. DW_PARTY_D PARTY_ID
DELIVER_TO_CUST_LOCATION_ID NUMBER 38 0 Customer location unique identifier. The final location where goods will be delivered that were previously received from a supplier. For Structured One-Time Address, this represents the delivery location. DW_CUSTOMER_LOCATION_D CUSTOMER_LOCATION_ID
SALES_ORDER_NUMBER VARCHAR2 64 Backing Sales Order Number
SALES_ORDER_LINE_NUMBER VARCHAR2 64 Backing Sales Order Line Number
SALES_ORDER_SCHEDULE_NUMBER VARCHAR2 64 Backing Sales Order Schedule Number
CUSTOMER_PO_NUMBER VARCHAR2 64 Customer PO Number
CUSTOMER_PO_LINE_NUMBER VARCHAR2 64 Customer PO Line Number
CUSTOMER_PO_SCHEDULE_NUMBER VARCHAR2 64 Customer PO Schedule Number
WORK_ORDER_ID NUMBER 38 0 Unique identifier for the work order
WORK_ORDER_OPERATION_ID NUMBER 38 0 The unique identifier of a work order operation
WORK_ORDER_NUMBER VARCHAR2 256 Number of the manufacturing work order
WORK_ORDER_OPERATION_SEQ NUMBER Indicates execution sequence of the work order operation
PARENT_REQ_LINE_ID NUMBER 38 0 Unique identifier of the parent requisition line for a modified requisition line
CANCEL_DATE DATE Cancel date
CANCEL_REASON VARCHAR2 256 Cancel reason
AGREEMENT_TYPE VARCHAR2 64 Source document type - Blanket or Contract
AGREEMENT_HEADER_ID NUMBER 38 0 Suggested source blanket agreement or contract header unique identifier
AGREEMENT_HEADER_NUMBER VARCHAR2 32 Suggested source blanket agreement or contract header number
AGREEMENT_LINE_ID NUMBER 38 0 Suggested source blanket agreement line identifier
AGREEMENT_LINE_NUMBER NUMBER 38 0 Suggested source blanket agreement line number
NEGOTIATION_HEADER_ID NUMBER 38 0 Reference to sourcing auction id
NEGOTIATION_NUMBER VARCHAR2 256 Reference to sourcing auction number
NEGOTIATION_LINE_NUMBER NUMBER Reference to sourcing auction line number
NEGOTIATION_REQUIRED_FLAG VARCHAR2 32 Indicates whether an RFQ is required prior to placement on a purchase order. Values will be Y or N. DW_Y_N_D_TL CODE
NEGOTIATED_BY_PREPARER_FLAG VARCHAR2 32 Indicates whether price has been negotiated by buyer. Values will be Y or N. DW_Y_N_D_TL CODE
FULFILLED_DATE DATE Fufilled_date for a given PO Line will be the max fufilled_date among its schedules. The fufilled date for a PO schedule is calculated as 1. min of SHIPMENT_CLOSED_DATE and CLOSED_FOR_INVOICE_DATE if RECEIPT_REQUIRED_FLAG and INSPECTION_REQUIRED_FLAG are marked as N Else 2. min of SHIPMENT_CLOSED_DATE and CLOSED_FOR_RECEIVING_DATE. Fulfill date will have value only if all the the schedule lines for that PO line is closed for Receiving or invoicing.
PROCESSED_DATE DATE Processed Date of version 0 of purchase order.
INTERFACE_SOURCE_CODE VARCHAR2 32 Source of requisition from requisition import. Values are DOO, SCO, INV etc.
EMERGENCY_REQ_FLAG VARCHAR2 32 Stores state of emergency requisition checkbox. Values will be Y or N. DW_Y_N_D_TL CODE
INTERNAL_TRANSFER_REQ_FLAG VARCHAR2 32 Indicates whether all lines of the requisition are for internal material transfer. Values will be Y or N.
REQUISITION_DOCUMENT_STATUS VARCHAR2 32 Requisition document status. Values are PENDING APPROVAL, APPROVED, CANCELED, REJECTED, WITHDRAWN etc. DW_POR_DOCUMENT_STATUS_D_TL CODE
DESCRIPTION VARCHAR2 256 Description for requisition
JUSTIFICATION VARCHAR2 999 Note to approver
EMERGENCY_PO_NUMBER VARCHAR2 32 Purchase order number reserved in advance for an emergency requisition
REQUISITION_BU_ID NUMBER 38 0 Requisition business unit identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
OVERRIDING_APPROVER_ID NUMBER 38 0 Overriding first approver identifier for a requisition for approval routing. DW_PERSON_NAME_CURRENT_D PERSON_ID
PREPARER_ID NUMBER 38 0 Unique identifier of the employee who prepared the requisition DW_PERSON_NAME_CURRENT_D PERSON_ID
CURRENCY_CODE VARCHAR2 32 Unique identifier for the requisition currency DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
REQ_BU_PRIMARY_LEDGER_ID NUMBER 38 0 Primary ledger identifier of requisition business unit DW_LEDGER_D LEDGER_ID
HEADER_CREATION_DATE DATE Indicates the date of creation of requisition header
HEADER_LAST_UPDATE_DATE VARCHAR2 128 Indicates the date of last update of requisition header
HEADER_CREATED_BY VARCHAR2 128 Indicates the user who created requisition header DW_USER_D USERNAME
HEADER_LAST_UPDATED_BY VARCHAR2 128 Indicates the user who last updated requisition header DW_USER_D USERNAME
REQ_FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
REQ_FISCAL_PERIOD_TYPE VARCHAR2 16 Accounting period type. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
FISCAL_PERIOD_NAME VARCHAR2 64 Accounting period name. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
FIRST_SUBMIT_DATE DATE Date when requisition was first submitted.
FIRST_SUBMITTER_ID NUMBER 38 0 Indicates the user who first submitted the requisition. DW_PERSON_NAME_CURRENT_D PERSON_ID
FIRST_APPROVAL_DATE DATE Date when requisition was first approved
FIRST_APPROVER_ID NUMBER 38 0 Indicates the user who first approved the requisition. DW_PERSON_NAME_CURRENT_D PERSON_ID
LAST_SUBMIT_DATE DATE Date when requisition was last submitted.
LAST_SUBMITTER_ID NUMBER 38 0 Indicates the user who last submitted the requisition. DW_PERSON_NAME_CURRENT_D PERSON_ID
LAST_APPROVAL_DATE DATE Date when requisition was last approved
LAST_APPROVER_ID NUMBER 38 0 Indicates the user who last approved the requisition. DW_PERSON_NAME_CURRENT_D PERSON_ID
NEGOTIATED_FLAG VARCHAR2 32 Values will be Y if requisition was negotiated through any RFQ/sourcing event, else N DW_Y_N_D_TL CODE
PROCESSED_FLAG VARCHAR2 32 Values will be Y if requisition is processed and converted into purchase order, else N DW_Y_N_D_TL CODE
FULFILLED_FLAG VARCHAR2 32 Values will be Y if requisition is processed and purchase order line is closed, else N DW_Y_N_D_TL CODE
LINE_PARENT_FLAG VARCHAR2 32 Value will be Y if the line is the parent requisition line for a modified requisition line, else N DW_Y_N_D_TL CODE
REQ_APPROVAL_CYCLE_TIME NUMBER Time taken to get requisition approved in first cycle i.e. from first submit date to first approval date
REQ_PROCESS_CYCLE_TIME NUMBER Time taken to process requisition i.e requisition line last approval date to processed date of purchase order version 0
REQ_APPROVAL_TO_FULFIL_TIME NUMBER Time taken to fulfil requisition i.e. from req line last approval date to purchase order line closed date
REQ_SUBMIT_TO_FULFIL_TIME NUMBER Time taken to fulfil requisition i.e. from req line last submit date to purchase order line closed date
PR_TO_PO_CYCLE_TIME NUMBER Time between requisition line last approval date and purchse order creation date