DBA Data[Home] [Help] [Dependency Information]

TABLE: GML.PO_COST_DTL

Object Details
Object Name: PO_COST_DTL
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.PO_COST_DTL
Subobject Name:
Status: VALID


PO_COST_DTL table holds the acquistion cost details for a purchase order or a stock receipt. DOC_TYPE column stores the information to determine whether this record is for a purchase order or a stock receipt. POS_ID stores the PO number or the stock receipt number to which the line references. LINE_ID column references the detail line of the PO or stock receipt which created this record. DOC_TYPE, POS_ID, LINE_ID and AQUI_COST_ID together uniquely identify a row in the table. For Stock Receipts, the user enters information for any Stock Receipt line. For PO's, the information is entered in Oracle Purchasing and stored in the table CPG_COST_DTL. When the PO is approved, it is transferred into OPM and the acquisition costs are copied into this table from CPG_COST_DTL.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_COST_DTL_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOC_TYPE
ColumnPOS_ID
ColumnLINE_ID
ColumnAQUI_COST_ID
PO_COST_DTL_I1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOC_TYPE
ColumnPO_HEADER_ID
ColumnPO_LINE_ID
ColumnLINE_LOCATION_ID
ColumnAQUI_COST_ID
Columns
Name Datatype Length Mandatory Comments
DOC_TYPE VARCHAR2 (4) Yes Determines which transaction created the row: "pord" - created from a po; "recv" - created from a stock receipt
POS_ID NUMBER (10) Yes Pointer to the document that created the row: "pord" - fk to po_ordr_hdr; "recv" - fk to po_recv_hdr
LINE_ID NUMBER (10) Yes Pointer to the line that created the row: "pord" - fk to op_ordr_dtl; "recv" - fk to po_recv_dtl
AQUI_COST_ID NUMBER (10) Yes Fk to po_cost_mst
COST_AMOUNT NUMBER

Monetary amount allocated to the row.
INCL_IND NUMBER (5) Yes Determines whether the amount is passed to the g/l for booking: 0 - do not pass amount; 1 - pass amount
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
TRANS_CNT NUMBER (10)
Not currently used
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
LINE_LOCATION_ID NUMBER

PO line location surrogate id from Oracle Purchasing
MIGRATION_IND NUMBER

Indicator as to whether this Record was migrated
PO_HEADER_ID NUMBER

PO header surrogate from Oracle Purchasing
PO_LINE_ID NUMBER

PO line surrogate id from Oracle Purchasing
TOTAL_COST NUMBER

Total Acquisiton Cost depending on the total_cost_flag.
TOTAL_COST_FLAG NUMBER

Indicator as to whether this acqusition cost for per unit or total cost
TOTAL_COST_BASIS NUMBER (2)
Basis for Application of Acquisition Cost: 0 - Based on PO Line Qty; 1 - Applied to each Receipt
Query Text

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


SELECT DOC_TYPE
,      POS_ID
,      LINE_ID
,      AQUI_COST_ID
,      COST_AMOUNT
,      INCL_IND
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      TEXT_CODE
,      TRANS_CNT
,      DELETE_MARK
,      LINE_LOCATION_ID
,      MIGRATION_IND
,      PO_HEADER_ID
,      PO_LINE_ID
,      TOTAL_COST
,      TOTAL_COST_FLAG
,      TOTAL_COST_BASIS
FROM GML.PO_COST_DTL;

Dependencies

[top of page]

GML.PO_COST_DTL does not reference any database object

GML.PO_COST_DTL is referenced by following:

SchemaGML
ViewPO_COST_DTL#