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: IGC.IGC_CBC_PO_PROCESS_EXCPTS_ALL

Object Details

Object Name:	IGC_CBC_PO_PROCESS_EXCPTS_ALL
Object Type:	TABLE
Owner:	IGC
Subobject Name:
Status:	VALID

When running processes like the Purchasing Year End process, the documents are validated before they can be processed. If the document fails validation a row is entered in this table. The Purchasing Year End Exception report then prints out a list of these exceptions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGC_CBC_PO_PE_NU1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONC_REQUEST_ID
IGC_CBC_PO_PE_NU2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_TYPE DOCUMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CONC_REQUEST_ID	NUMBER	(15)	Yes	The Request Id of the Concurrent Request
DOCUMENT_TYPE	VARCHAR2	(3)		The Type of Document i.e PO, REQ, REL
DOCUMENT_ID	NUMBER	(15)		The Document Header Id. If the document type is a PO, this column would hold the PO_HEADER_ID. If the docment type is REL, this column would hold the PO_RELEASE_ID and if the document type is REQ, this column would hold the REQUISITION_HEADER_ID
LINE_ID	NUMBER	(15)		The Document Line Id. If the document type is a PO, this column would hold the PO_LINE_ID. If the docment type is REL, this column would be blank and if the document type is REQ, this column would hold the REQUISITION_LINE_ID
LINE_LOCATION_ID	NUMBER	(15)		The Document Line Location Id. If the document type is a PO or a REL, this column would hold the LINE_LOCATION_ID from PO_LINE_LOCATIONS. If the docment type is REQ, this column would be blank.
DISTRIBUTION_ID	NUMBER	(15)		The Document Distribution Id. If the document type is a PO or a REL, this column would hold the DISTRIBUTION_ID from PO_DISTRIBUTIONS. If the docment type is REQ, this column would hold the DISTRIBUTION_ID from PO_REQ_DISTRIBUTIONS.
ORG_ID	NUMBER	(15)		Organization identifier
SOB_ID	NUMBER	(15)	Yes	Set of Books Id
PROCESS_TYPE	VARCHAR2	(3)	Yes	Process Type. Would hold values like 'YEP' - for Year End Process
PROCESS_PHASE	VARCHAR2	(1)		Process Phase. Would hold values like 'P' - Preliminary or 'F' Final
EXCEPTION_CODE	VARCHAR2	(30)		The message code for the validation failure.
EXCEPTION_REASON	VARCHAR2	(2000)	Yes	The text reason for the validation failure.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).

Query Text

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


SELECT CONC_REQUEST_ID
,      DOCUMENT_TYPE
,      DOCUMENT_ID
,      LINE_ID
,      LINE_LOCATION_ID
,      DISTRIBUTION_ID
,      ORG_ID
,      SOB_ID
,      PROCESS_TYPE
,      PROCESS_PHASE
,      EXCEPTION_CODE
,      EXCEPTION_REASON
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM IGC.IGC_CBC_PO_PROCESS_EXCPTS_ALL;

Dependencies

[top of page]

IGC.IGC_CBC_PO_PROCESS_EXCPTS_ALL does not reference any database object

IGC.IGC_CBC_PO_PROCESS_EXCPTS_ALL is referenced by following:

APPS: IGC_CBC_PO_PROCESS_EXCPTS; IGC_CBC_PO_PROCESS_EXCPTS_ALL