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: GML.PO_DIST_DTL

Object Details

Object Name:	PO_DIST_DTL
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.PO_DIST_DTL
Subobject Name:
Status:	VALID

PO_DIST_DTL stores the General Ledger (GL) distribution for items and acquisition costs for both purchase orders and stock receipt transactions. The GL distribution is generated when PO's are transferred from Oracle Purchasing into OPM and when Stock Receipts in OPM are saved. In Stock Receipts, users can view and edit the GL distribution.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_DIST_DTL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOC_TYPE DOC_ID LINE_ID RECV_SEQ_NO SEQ_NO

Columns

Name	Datatype	Length	Mandatory	Comments
DOC_TYPE	VARCHAR2	(4)	Yes	Determines the origin of the document: "pord" - purchase order; "recv" - stock receipts
DOC_ID	NUMBER	(10)	Yes	Fk to the document header: "pord" - op_ordr_hdr (purchase order); "recv" - op_recv_hdr (stock recipt)
LINE_ID	NUMBER	(10)	Yes	Fk to document line: "pord" - po_ordr_dtl (purchase order); "recv" - po_recv_dtl (stock receipt)
RECV_SEQ_NO	NUMBER	(5)	Yes	Additional counter.
SEQ_NO	NUMBER	(5)	Yes	Sequence number for the line.
AQUI_COST_ID	NUMBER	(10)		Fk to po_cost_mst
ITEM_ID	NUMBER	(10)	Yes	Fk to ic_item_mst
ACCTG_UNIT_ID	NUMBER	(10)	Yes	Fk to gl_accu_mst.
ACCT_ID	NUMBER	(10)	Yes	Fk to gl_acct_mst.
ACCT_DESC	VARCHAR2	(70)	Yes	Description of the account
ACCT_TTL_TYPE	NUMBER	(5)	Yes	Fk to gl_acct_ttl.
AMOUNT_BASE	NUMBER		Yes	Monetary amount converted to base currency.
AMOUNT_TRANS	NUMBER		Yes	Monetary amount in the transaction currency.
QUANTITY	NUMBER		Yes	Quanity of the transaction.
QUANTITY_UM	VARCHAR2	(4)	Yes	Fk to sy_uoms_mst.
PROJECT_NO	VARCHAR2	(16)		Not currently supported
GL_POSTED_IND	NUMBER	(5)	Yes	Reserved for future use.
EXPORTED_DATE	DATE		Yes	Indicates whether the transaction has been posted to oracle financials. Defaults to sy$mindate.
CURRENCY_TRANS	VARCHAR2	(4)	Yes	Curency of the transaction
CURRENCY_BASE	VARCHAR2	(4)	Yes	Base currency.
CO_CODE	VARCHAR2	(4)	Yes	Company code for gl posting purposes. Fk to sy_orgn_mst.
LEDGER_CODE	VARCHAR2	(4)	Yes	Fk to gl_ldgr_mst
FISCAL_YEAR	NUMBER	(5)	Yes	Fiscal year of the transaction.
PERIOD	NUMBER	(5)	Yes	Fiscal period of the transaction.
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.

Query Text

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


SELECT DOC_TYPE
,      DOC_ID
,      LINE_ID
,      RECV_SEQ_NO
,      SEQ_NO
,      AQUI_COST_ID
,      ITEM_ID
,      ACCTG_UNIT_ID
,      ACCT_ID
,      ACCT_DESC
,      ACCT_TTL_TYPE
,      AMOUNT_BASE
,      AMOUNT_TRANS
,      QUANTITY
,      QUANTITY_UM
,      PROJECT_NO
,      GL_POSTED_IND
,      EXPORTED_DATE
,      CURRENCY_TRANS
,      CURRENCY_BASE
,      CO_CODE
,      LEDGER_CODE
,      FISCAL_YEAR
,      PERIOD
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
FROM GML.PO_DIST_DTL;

Dependencies

[top of page]

GML.PO_DIST_DTL does not reference any database object

GML.PO_DIST_DTL is referenced by following:

APPS: PO_DIST_DTL