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.CPG_ORAGEMS_MAPPING

Object Details

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

Table which maps a standard or planned purchase order entered in Oracle Purchasing with the PO or BPO created in OPM. Table is populated via the OPM Common Purchasing Synchronization program.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CPG_ORAGEMS_MAPPING_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PO_HEADER_ID PO_LINE_ID PO_LINE_LOCATION_ID
CPG_ORAGEMS_MAPPING_I1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_LINE_LOCATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PO_HEADER_ID	NUMBER			PO header surrogate from Oracle Purchasing
PO_LINE_ID	NUMBER			PO line surrogate id from Oracle Purchasing
PO_LINE_LOCATION_ID	NUMBER			PO line location surrogate id from Oracle Purchasing
PO_ID	NUMBER	(10)		Sorrugate id for PO header created in OPM
LINE_ID	NUMBER	(10)		Surrogate id for PO line created in OPM
PO_NO	VARCHAR2	(40)		Purchase order number for PO in Oracle Purchasing; will become the PO number in OPM
BPO_ID	NUMBER			Surrogate id for Blanket Purchase Order header created in OPM
BPO_LINE_ID	NUMBER			Surrogate id for BPO line created in OPM
RELEASE_NUM	NUMBER			Release number from Oracle Purchasing
PO_RELEASE_ID	NUMBER			PO release surrogate from Oracle Purchasing
PO_STATUS	VARCHAR2	(25)		PO status from PO in Oracle Purchasing
TRANSACTION_TYPE	VARCHAR2	(10)		Type of purchase order - STANDARD or PLANNED
TIME_STAMP	DATE			Date and time when record inserted
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
MIGRATION_IND	VARCHAR2	(1)		Migration Indicator

Query Text

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


SELECT PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_ID
,      LINE_ID
,      PO_NO
,      BPO_ID
,      BPO_LINE_ID
,      RELEASE_NUM
,      PO_RELEASE_ID
,      PO_STATUS
,      TRANSACTION_TYPE
,      TIME_STAMP
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      MIGRATION_IND
FROM GML.CPG_ORAGEMS_MAPPING;

Dependencies

[top of page]

GML.CPG_ORAGEMS_MAPPING does not reference any database object

GML.CPG_ORAGEMS_MAPPING is referenced by following:

APPS: CPG_ORAGEMS_MAPPING