eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: POA.POA_DBI_REQ_F

Object Details

Object Name:	POA_DBI_REQ_F
Object Type:	TABLE
Owner:	POA
Subobject Name:
Status:	VALID

Requisition Line Fact for DBI - only insert and update allowed

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
POA_DBI_REQ_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	REQ_LINE_ID
POA_DBI_REQ_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PO_APPROVED_DATE BUYER_ID CATEGORY_ID PO_ITEM_ID
POA_DBI_REQ_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PO_APPROVED_DATE REQUESTER_ID SUPPLIER_ID SHIP_TO_ORG_ID
POA_DBI_REQ_F_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	REQ_FULFILLED_DATE BUYER_ID CATEGORY_ID PO_ITEM_ID
POA_DBI_REQ_F_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	REQ_FULFILLED_DATE REQUESTER_ID SUPPLIER_ID SHIP_TO_ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REQ_LINE_ID	NUMBER		Yes	Requisition Line Id
REQ_HEADER_ID	NUMBER		Yes	Requisition Header Id
PO_LINE_LOCATION_ID	NUMBER			PO Shipment Id
REQ_CREATION_OU_ID	NUMBER		Yes	Requisition Creation OU
REQ_CREATION_DATE	DATE		Yes	Requisition Creation Date
REQ_APPROVED_DATE	DATE			Requisition Approved Date
PO_CREATION_OU_ID	NUMBER			PO Creation OU Id
PO_CREATION_DATE	DATE			PO Creation Date
PO_SUBMIT_DATE	DATE			PO Submit Date
PO_APPROVED_DATE	DATE			PO Approved Date
REQ_FULFILLED_DATE	DATE			Requisition Fulfilled Date
EXPECTED_DATE	DATE			Expected Date
SUPPLIER_ID	NUMBER			Supplier Id
SUPPLIER_SITE_ID	NUMBER			Supplier Site Id
CATEGORY_ID	NUMBER			Category Id
PO_ITEM_ID	NUMBER			PO Item Id
BUYER_ID	NUMBER			Buyer Id
ORG_ID	NUMBER			Operating Unit Id
SHIP_TO_ORG_ID	NUMBER			Ship To Organization Id
REQUESTER_ID	NUMBER			Requester Id
LINE_TYPE_ID	NUMBER			Line Type Id
PREPARER_ID	NUMBER			Requisitions Preparer Id
UNIT_PRICE	NUMBER			Unit Price
LINE_QUANTITY	NUMBER			Quantity stamped on PO if exists else Requisition Quantity
LINE_AMOUNT_T	NUMBER			Amount in Transactional Currency
LINE_AMOUNT_B	NUMBER			Line Amount in Functional Currency
LINE_AMOUNT_G	NUMBER			Line Amount in Global Currency
LINE_AMOUNT_SG	NUMBER			Line Amount in Secondary Global Currency
EMERGENCY_FLAG	VARCHAR2	(1)		Emergency Flag
URGENT_FLAG	VARCHAR2	(1)		Urgent Flag
SOURCING_FLAG	VARCHAR2	(1)		Sourcing Flag
INCLUDE_IN_UFR	VARCHAR2	(1)		Include in UFR Flag
PO_REVISIONS	NUMBER			PO Revisions
PO_CREATION_METHOD	VARCHAR2	(30)		PO Creation Method
FUNC_CUR_CODE	VARCHAR2	(25)		Functional Currency Code
FUNC_CUR_CONV_RATE	NUMBER			Currency Conversion Rate between Transactional and Functional Currency
GLOBAL_CUR_CONV_RATE	NUMBER			Currency Conversion Rate between Functional and Global Currency
SGLOBAL_CUR_CONV_RATE	NUMBER			Currency Conversion Rate between Functional and Secondary Global Currency
BASE_UOM	VARCHAR2	(25)		Base Unit of Measure
TRANSACTION_UOM	VARCHAR2	(25)		Transaction Unit of Measure
BASE_UOM_CONV_RATE	NUMBER			Conversion Rate from Transaction UOM to Base UOM
CREATED_BY	NUMBER		Yes	standard WHO column
LAST_UPDATE_LOGIN	NUMBER			standard WHO column
CREATION_DATE	DATE		Yes	standard WHO column
LAST_UPDATED_BY	NUMBER		Yes	standard WHO column
LAST_UPDATE_DATE	DATE		Yes	standard WHO column
UNPROC_PED_FLAG	VARCHAR2	(1)		Unprocessed Past Expected Date Flag

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQ_LINE_ID
,      REQ_HEADER_ID
,      PO_LINE_LOCATION_ID
,      REQ_CREATION_OU_ID
,      REQ_CREATION_DATE
,      REQ_APPROVED_DATE
,      PO_CREATION_OU_ID
,      PO_CREATION_DATE
,      PO_SUBMIT_DATE
,      PO_APPROVED_DATE
,      REQ_FULFILLED_DATE
,      EXPECTED_DATE
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      CATEGORY_ID
,      PO_ITEM_ID
,      BUYER_ID
,      ORG_ID
,      SHIP_TO_ORG_ID
,      REQUESTER_ID
,      LINE_TYPE_ID
,      PREPARER_ID
,      UNIT_PRICE
,      LINE_QUANTITY
,      LINE_AMOUNT_T
,      LINE_AMOUNT_B
,      LINE_AMOUNT_G
,      LINE_AMOUNT_SG
,      EMERGENCY_FLAG
,      URGENT_FLAG
,      SOURCING_FLAG
,      INCLUDE_IN_UFR
,      PO_REVISIONS
,      PO_CREATION_METHOD
,      FUNC_CUR_CODE
,      FUNC_CUR_CONV_RATE
,      GLOBAL_CUR_CONV_RATE
,      SGLOBAL_CUR_CONV_RATE
,      BASE_UOM
,      TRANSACTION_UOM
,      BASE_UOM_CONV_RATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      UNPROC_PED_FLAG
FROM POA.POA_DBI_REQ_F;

Dependencies

[top of page]

POA.POA_DBI_REQ_F does not reference any database object

POA.POA_DBI_REQ_F is referenced by following:

APPS: POA_DBI_REQ_F; POA_REQ_000_MV; POA_REQ_001_MV; POA_REQ_002_MV