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_ARCH

Object Details

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

Archive table for mapping between Oracle Purchase Order and Purchase Order created in OPM.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
PO_HEADER_ID	NUMBER			PO header surrogate from Oracle Purchasing
PO_LINE_ID	NUMBER			PO line surrogate from Oracle Purchasing
PO_LINE_LOCATION_ID	NUMBER			PO line location surrogate from Oracle Purchasing
PO_ID	NUMBER	(10)		Surrogate id for PO header in OPM
LINE_ID	NUMBER	(10)		PO line surrogate for PO line in OPM
PO_NO	VARCHAR2	(40)		Purchase order number from Oracle Purchasing; will become PO number in OPM
BPO_ID	NUMBER			Blanket Purchase Order header surrogate id in OPM
BPO_LINE_ID	NUMBER			Surrogate id for BPO line in OPM
RELEASE_NUM	NUMBER			Release number from Oracle Purchasing
PO_RELEASE_ID	NUMBER			Surrogate id for PO Release from Oracle Purchasing
PO_STATUS	VARCHAR2	(25)		Status of PO from Oracle Purchasing
TRANSACTION_TYPE	VARCHAR2	(10)		Type of Purchase Order - STANDARD or PLANNED
TIME_STAMP	DATE			Time and date 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

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
FROM GML.CPG_ORAGEMS_ARCH;

Dependencies

[top of page]

GML.CPG_ORAGEMS_ARCH does not reference any database object

GML.CPG_ORAGEMS_ARCH is referenced by following:

APPS: CPG_ORAGEMS_ARCH