DW_REQUISITION_AGG

Details

Module: Purchasing

SYSTEM_GEN_PK

Name	Datatype	Length	Precision	Not Null	Comments	Referred Table	Referred Column
SYSTEM_GEN_PK	VARCHAR2	512		True	Generated Primary Key for Internal Use Only
SOURCE_RECORD_ID	VARCHAR2	512			This column is for Oracle Internal use only. System Generated
PO_PROC_BU_ID	NUMBER	38	0		Procurement business unit identifier
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
REQUISITION_BU_ID	NUMBER	38	0		Requisition business unit identifier
REQ_BU_PRIMARY_LEDGER_ID	NUMBER	38	0		Primary ledger identifier of requisition business unit
REQ_FISCAL_PERIOD_SET_NAME	VARCHAR2	16			Accounting calendar name.
REQ_FISCAL_PERIOD_TYPE	VARCHAR2	16			Accounting period type.
REQUISITION_HEADER_CREATION_PERIOD	VARCHAR2	64			Accounting period name.
GLOBAL_CURRENCY_CODE	VARCHAR2	16			Global currency code.	DW_CURRENCY_DETAILS_D_TL	CURRENCY_CODE
REQUISITION_AMOUNT	NUMBER				Requisition amount in global currency
REQUISITION_COUNT	NUMBER				Count of requisitions
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
REQ_APPROVAL_CYCLE_TIME	NUMBER				Time taken to get requisition approved in first cycle i.e. from first submit date to first approval date
COUNT_OF_FULFILLED_REQ	NUMBER				Count of requisition line id from last submit date to purchase order line closed date
COUNT_OF_APPROVED_REQ	NUMBER				Count of requisition header id from first submit date to first approval date