[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
POA.POA_DBI_REQ_F does not reference any database object
POA.POA_DBI_REQ_F is referenced by following:
|
|
|