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_POD_F

Object Details

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

PO Distribution base table for DBI - only update and insert are allowed.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
POA_DBI_POD_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	PO_DISTRIBUTION_ID
POA_DBI_POD_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	APPROVED_DATE CATEGORY_ID PO_ITEM_ID
POA_DBI_POD_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	APPROVED_DATE SUPPLIER_ID SUPPLIER_SITE_ID
POA_DBI_POD_F_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	APPROVED_DATE BUYER_ID CREATION_OPERATING_UNIT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PO_DISTRIBUTION_ID	NUMBER		Yes	primary key
PO_HEADER_ID	NUMBER		Yes	PO Header Id
PO_LINE_ID	NUMBER		Yes	PO Line Id
PO_RELEASE_ID	NUMBER			PO Release Id
CREATION_OPERATING_UNIT_ID	NUMBER			Operating Unit where the PO was created
SHIP_TO_ORG_ID	NUMBER			Ship-to Organization
APPROVED_DATE	DATE			Ealiest approval date for the PO Distribution
DISTRIBUTION_CREATION_DATE	DATE		Yes	Creation Date of the PO Distribution
SUPPLIER_ID	NUMBER			Supplier ID
SUPPLIER_SITE_ID	NUMBER			Supplier Site Id
PO_ITEM_ID	NUMBER		Yes	Purchased Item ID
CATEGORY_ID	NUMBER			Category on the PO Line
BUYER_ID	NUMBER		Yes	Buyer Id
CODE_COMBINATION_ID	NUMBER			Code Combination Id
FUNC_CUR_CODE	VARCHAR2	(25)		Functional Currency Code
GLOBAL_CUR_CONV_RATE	NUMBER			Functional to Global conversion rate
BASE_UOM_CONV_RATE	NUMBER			Conversion rate to the base Unit of Measure of an item
PURCHASE_AMOUNT_B	NUMBER			purchase amount in functional currency
CONTRACT_AMOUNT_B	NUMBER			contract amount in functional currency
NON_CONTRACT_AMOUNT_B	NUMBER			non-contract purchases amount in functional currency
POT_CONTRACT_AMOUNT_B	NUMBER			Contract Leakage amount in functional currency
POT_SAVINGS_AMOUNT_B	NUMBER			Potential Savings amount in functional currency
UNIT_PRICE	NUMBER			Unit Price
QUANTITY	NUMBER			Quantity
CREATION_MODE	VARCHAR2	(10)		Creation Mode
ORDER_TYPE	VARCHAR2	(25)		Order Type
CATALOG_TYPE	VARCHAR2	(30)		Catalog Type
DESTINATION_TYPE_CODE	VARCHAR2	(25)		Destination Type Code
AMT_BILLED	NUMBER			Amount Billed
QTY_BILLED	NUMBER			Quantity Billed
QTY_CANCELLED	NUMBER			Quantity Cancelled
START_DATE_ACTIVE	DATE			Date when this row became active
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
POTENTIAL_CONTRACT_ID	NUMBER			Potential Contract Id
SHIPMENT_TYPE	VARCHAR2	(25)		Shipment Type
APPS_SOURCE_CODE	VARCHAR2	(25)		Apps Source Code - PO, POR
FROM_DOCUMENT_TYPE	VARCHAR2	(25)		From Document Type
FROM_DOCUMENT_ID	NUMBER			From Document Id
CONSIGNED_CODE	NUMBER			Consigned Code - 0 for normal shipment, 1 for consigned shipment, 2 for consumption advice
BASE_UOM	VARCHAR2	(25)		Base UOM
TRANSACTION_UOM	VARCHAR2	(25)		Transaction UOM
REQUESTOR_ID	NUMBER			Requestor Id
FUNC_CUR_CONV_RATE	NUMBER			Conversion Rate from Transactional Currency to Functional (OU) currency
SGLOBAL_CUR_CONV_RATE	NUMBER			Conversion Rate from Functional to Secondary Global Currency
EXPECTED_DATE	DATE			Expected Date
DAYS_LATE_RECEIPT_ALLOWED	NUMBER			Days Late Receipt Allowed
DAYS_EARLY_RECEIPT_ALLOWED	NUMBER			Days Early Receipt Allowed
PRICE_OVERRIDE	NUMBER			PO Price
LINE_LOCATION_ID	NUMBER			PO Shipment Id
ITEM_ID	NUMBER			Item Id
MATCHING_BASIS	VARCHAR2	(30)		Matching Basis
RECEIVING_ROUTING_ID	NUMBER			Receiving Routing Id
COMPANY_ID	NUMBER			Company Id
COST_CENTER_ID	NUMBER			Cost Center Id
QTY_FINANCED	NUMBER			Quantity Financed
AMT_FINANCED	NUMBER			Amount Financed
QTY_RECOUPED	NUMBER			Quantity Recouped
AMT_RECOUPED	NUMBER			Amount Recouped
PAYMENT_TYPE	VARCHAR2	(30)		Payment Type
COMPLEX_WORK_FLAG	VARCHAR2	(1)		Complex Work Flag indicating a Complex Work Procurement
NON_ZERO_QUANTITY	NUMBER			Number of units having NON-zero PO Purchase Price
AUCTION_HEADER_ID	NUMBER			Auction Header Identifier
AUCTION_LINE_NUMBER	NUMBER			Auction Line Number
BID_NUMBER	NUMBER			Bid Number
BID_LINE_NUMBER	NUMBER			Bid Line Number
NEGOTIATION_CREATOR_ID	NUMBER			Negotiation Creator Identifier
DOCTYPE_ID	NUMBER			Document Type Identifier
NEG_CURRENT_PRICE	NUMBER			Current Price
NEG_FUNC_CUR_CODE	VARCHAR2	(25)		Functional Currency Code
NEG_FUNC_CUR_CONV_RATE	NUMBER			Functional Currency Conversion Rate
NEG_GLOBAL_CUR_CONV_RATE	NUMBER			Global Currency Conversion Rate
NEG_SGLOBAL_CUR_CONV_RATE	NUMBER			Secondary Global Currency Conversion Rate
NEG_TRANSACTION_UOM	VARCHAR2	(25)		Transaction UOM
NEG_BASE_UOM	VARCHAR2	(25)		Base UOM
NEG_BASE_UOM_CONV_RATE	NUMBER			Conversion Rate from Transaction UOM to Base UOM
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_DISTRIBUTION_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_RELEASE_ID
,      CREATION_OPERATING_UNIT_ID
,      SHIP_TO_ORG_ID
,      APPROVED_DATE
,      DISTRIBUTION_CREATION_DATE
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      PO_ITEM_ID
,      CATEGORY_ID
,      BUYER_ID
,      CODE_COMBINATION_ID
,      FUNC_CUR_CODE
,      GLOBAL_CUR_CONV_RATE
,      BASE_UOM_CONV_RATE
,      PURCHASE_AMOUNT_B
,      CONTRACT_AMOUNT_B
,      NON_CONTRACT_AMOUNT_B
,      POT_CONTRACT_AMOUNT_B
,      POT_SAVINGS_AMOUNT_B
,      UNIT_PRICE
,      QUANTITY
,      CREATION_MODE
,      ORDER_TYPE
,      CATALOG_TYPE
,      DESTINATION_TYPE_CODE
,      AMT_BILLED
,      QTY_BILLED
,      QTY_CANCELLED
,      START_DATE_ACTIVE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      POTENTIAL_CONTRACT_ID
,      SHIPMENT_TYPE
,      APPS_SOURCE_CODE
,      FROM_DOCUMENT_TYPE
,      FROM_DOCUMENT_ID
,      CONSIGNED_CODE
,      BASE_UOM
,      TRANSACTION_UOM
,      REQUESTOR_ID
,      FUNC_CUR_CONV_RATE
,      SGLOBAL_CUR_CONV_RATE
,      EXPECTED_DATE
,      DAYS_LATE_RECEIPT_ALLOWED
,      DAYS_EARLY_RECEIPT_ALLOWED
,      PRICE_OVERRIDE
,      LINE_LOCATION_ID
,      ITEM_ID
,      MATCHING_BASIS
,      RECEIVING_ROUTING_ID
,      COMPANY_ID
,      COST_CENTER_ID
,      QTY_FINANCED
,      AMT_FINANCED
,      QTY_RECOUPED
,      AMT_RECOUPED
,      PAYMENT_TYPE
,      COMPLEX_WORK_FLAG
,      NON_ZERO_QUANTITY
,      AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      BID_NUMBER
,      BID_LINE_NUMBER
,      NEGOTIATION_CREATOR_ID
,      DOCTYPE_ID
,      NEG_CURRENT_PRICE
,      NEG_FUNC_CUR_CODE
,      NEG_FUNC_CUR_CONV_RATE
,      NEG_GLOBAL_CUR_CONV_RATE
,      NEG_SGLOBAL_CUR_CONV_RATE
,      NEG_TRANSACTION_UOM
,      NEG_BASE_UOM
,      NEG_BASE_UOM_CONV_RATE
,      NEGOTIATED_BY_PREPARER_FLAG
FROM POA.POA_DBI_POD_F;

Dependencies

[top of page]

POA.POA_DBI_POD_F does not reference any database object

POA.POA_DBI_POD_F is referenced by following:

APPS: POA_API_BS_J_MV; POA_DBI_PLL_MV; POA_DBI_POD_F; POA_POD_BS_J_MV; POA_PQC_BS_J_MV