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

TABLE: GML.CPG_COST_DTL

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


This table contains OPM acquisition costs entered against a purchase order line in Oracle Purchasing. This information is entered during Purchase Order Entry in Oracle Purchasing and the data is transferred to OPM via the OPM Common Purchasing Synchronization program.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Yes Purchase order header surrogate id from Oracle Purchasing
PO_LINE_ID NUMBER
Yes Purchase order line surrogate id from Oracle Purchasing
AQUI_COST_ID NUMBER
Yes Acquisition cost surrogate; FK to po_cost_mst
DESCRIPTION VARCHAR2 (60)
Acquisition cost description
COST_AMOUNT NUMBER

Per unit acquisition cost in currency of PO
INCL_IND NUMBER

Include indicator; value of 0 (cost is expensed) or 1 (cost is included in Inventory)
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
LINE_LOCATION_ID NUMBER
Yes Surrogate id for po line location
Query Text

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


SELECT PO_HEADER_ID
,      PO_LINE_ID
,      AQUI_COST_ID
,      DESCRIPTION
,      COST_AMOUNT
,      INCL_IND
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      LINE_LOCATION_ID
FROM GML.CPG_COST_DTL;

Dependencies

[top of page]

GML.CPG_COST_DTL does not reference any database object

GML.CPG_COST_DTL is referenced by following:

SchemaAPPS
SynonymCPG_COST_DTL