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]

VIEW: APPS.POA_DBI_POD_F_V

Object Details

Object Name:	POA_DBI_POD_F_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

View based on PO distribution fact and commodiy assignment table

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.POA_DBI_POD_F_V references the following:

APPS: FII_COM_CC_DIM_MAPS; POA_DBI_POD_F; PO_COMMODITY_CATEGORIES

APPS.POA_DBI_POD_F_V is not referenced by any database object