[Home] [Help] [Dependency Information]
Object Name: | POA_DBI_POD_F_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
View based on PO distribution fact and commodiy assignment table
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PO_HEADER_ID | NUMBER | Yes | PO Header Id | |
PO_RELEASE_ID | NUMBER | PO Release Id | ||
SHIPMENT_TYPE | VARCHAR2 | (25) | Shipment Type (Standard/Blanket/Scheduled) | |
FROM_DOCUMENT_ID | NUMBER | From Document Id | ||
POTENTIAL_CONTRACT_ID | NUMBER | Potential Contract Id | ||
CONSIGNED_CODE | NUMBER | Consigned Code | ||
APPROVED_DATE | DATE | Approved Date | ||
ORG_ID | NUMBER | Operating Unit where the PO was created | ||
COMMODITY_ID | NUMBER | Commodity ID | ||
BASE_UOM | VARCHAR2 | (25) | Base UOM | |
SUPPLIER_ID | NUMBER | Supplier Id | ||
SUPPLIER_SITE_ID | NUMBER | Supplier Site Id | ||
CATEGORY_ID | NUMBER | Category Id | ||
PO_ITEM_ID | NUMBER | Yes | PO Item Id | |
BUYER_ID | NUMBER | Yes | Buyer Id | |
COMPANY_ID | NUMBER | (15) | Company Id | |
COST_CENTER_ID | NUMBER | (15) | Cost Center Id | |
CONTRACT_TYPE | NUMBER | Contract Type | ||
QUANTITY | NUMBER | Quantity | ||
PURCHASE_AMT_B | NUMBER | Purchased Amount in functional currency | ||
PURCHASE_AMT_G | NUMBER | Purchased Amount in global currency | ||
PURCHASE_AMT_SG | NUMBER | Purchase Amount in Secondary Global Currency | ||
P_CONTRACT_AMT_B | NUMBER | Potential Contract Amount in functional currency | ||
P_CONTRACT_AMT_G | NUMBER | Potential Contract Amount in global currency | ||
P_CONTRACT_AMT_SG | NUMBER | Potential Contract Amount in Secondary Global Currency | ||
N_CONTRACT_AMT_B | NUMBER | Non-Contract Amount in functional currency | ||
N_CONTRACT_AMT_G | NUMBER | Non-Contract Amount in global currency | ||
N_CONTRACT_AMT_SG | NUMBER | Non-Contract Amount in Secondary Global Currency | ||
P_SAVINGS_AMT_B | NUMBER | Potential Savings Amount in functional currency | ||
P_SAVINGS_AMT_G | NUMBER | Potential Savings Amount in global currency | ||
P_SAVINGS_AMT_SG | NUMBER | Potential Savings Amount in Secondary Global Currency | ||
CONTRACT_AMT_B | NUMBER | Contract Amount in functional currency | ||
CONTRACT_AMT_G | NUMBER | Contract Amount in functional currency | ||
CONTRACT_AMT_SG | NUMBER | Contract Amount in Secondary Global Currency | ||
NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2 | (1) | Negotiated by Preparer Flag |
Cut, paste (and edit) the following text to query this object:
SELECT PO_HEADER_ID
, PO_RELEASE_ID
, SHIPMENT_TYPE
, FROM_DOCUMENT_ID
, POTENTIAL_CONTRACT_ID
, CONSIGNED_CODE
, APPROVED_DATE
, ORG_ID
, COMMODITY_ID
, BASE_UOM
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, CATEGORY_ID
, PO_ITEM_ID
, BUYER_ID
, COMPANY_ID
, COST_CENTER_ID
, CONTRACT_TYPE
, QUANTITY
, PURCHASE_AMT_B
, PURCHASE_AMT_G
, PURCHASE_AMT_SG
, P_CONTRACT_AMT_B
, P_CONTRACT_AMT_G
, P_CONTRACT_AMT_SG
, N_CONTRACT_AMT_B
, N_CONTRACT_AMT_G
, N_CONTRACT_AMT_SG
, P_SAVINGS_AMT_B
, P_SAVINGS_AMT_G
, P_SAVINGS_AMT_SG
, CONTRACT_AMT_B
, CONTRACT_AMT_G
, CONTRACT_AMT_SG
, NEGOTIATED_BY_PREPARER_FLAG
FROM APPS.POA_DBI_POD_F_V;
APPS.POA_DBI_POD_F_V is not referenced by any database object
|
|
|