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

Object Details

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

Shadow table of PO_RECV_HST for EFC migration.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GML_PO_MIG_ERRORS_I1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PO_HEADER_ID PO_LINE_ID LINE_LOCATION_ID
GML_PO_MIG_ERRORS_I2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SHIPMENT_HEADER_ID SHIPMENT_LINE_ID
GML_PO_MIG_ERRORS_I3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID
GML_PO_MIG_ERRORS_I4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUISITION_HEADER_ID REQUISITION_LINE_ID
GML_PO_MIG_ERRORS_I5	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PO_ID LINE_ID AQUI_COST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MIGRATION_TYPE	VARCHAR2	(25)		Migration type meaning such as PURCHAING ,RECEIVING , TRANSACTIONS etc
PO_HEADER_ID	NUMBER			Error PO Header identifier
PO_LINE_ID	NUMBER			Error PO Line Identifier
LINE_LOCATION_ID	NUMBER			Error PO Shipment Identifier
PO_RELEASE_ID	NUMBER			Error PO Release Identifier
TRANSACTION_ID	NUMBER			Error Receiving Transaction Identifier
SHIPMENT_HEADER_ID	NUMBER			Error Shipment Header Identifier
SHIPMENT_LINE_ID	NUMBER			Error Shipment Line Identifier
REQUISITION_HEADER_ID	NUMBER			Error Requisition Header Identifier
REQUISITION_LINE_ID	NUMBER			Error Requisition Line Identifier
COLUMN_NAME	VARCHAR2	(30)		Error Column Name
TABLE_NAME	VARCHAR2	(30)		Error Table Name
ERROR_MESSAGE	VARCHAR2	(2000)		Error Message text
CREATION_DATE	DATE		Yes	standard who column
LAST_UPDATE_DATE	DATE		Yes	standard who column
LINE_ID	NUMBER			Sorrugate id for PO line created in OPM
PO_ID	NUMBER			Sorrugate id for PO header created in OPM
AQUI_COST_ID	NUMBER			Acquisition Cost ID

Query Text

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


SELECT MIGRATION_TYPE
,      PO_HEADER_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      PO_RELEASE_ID
,      TRANSACTION_ID
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      REQUISITION_HEADER_ID
,      REQUISITION_LINE_ID
,      COLUMN_NAME
,      TABLE_NAME
,      ERROR_MESSAGE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LINE_ID
,      PO_ID
,      AQUI_COST_ID
FROM GML.GML_PO_MIG_ERRORS;

Dependencies

[top of page]

GML.GML_PO_MIG_ERRORS does not reference any database object

GML.GML_PO_MIG_ERRORS is referenced by following:

GML: GML_PO_MIG_ERRORS#