[Home] [Help] [Dependency Information]

VIEW: APPS.IC_TRAN_VW1

Object Details

Object Name:	IC_TRAN_VW1
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMI.IC_TRAN_VW1
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A public view which may be useful for custom reporting or other data
requirements.

Transaction view. Contains data on all undeleted
transactions in ic_tran_pnd, plus all transactions
in ic_tran_cmp. Used in Single Level Lot Source
inquiry, Single Level Where Used inquiry, and the Daily
Transaction Detail report.

[View Source]

Columns

Query Text

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

SELECT CO_CODE
,      COMPLETED_IND
,      CREATION_DATE
,      DOC_ID
,      DOC_LINE
,      DOC_TYPE
,      ITEM_ID
,      LINE_ID
,      LINE_TYPE
,      LOCATION
,      LOT_ID
,      LOT_STATUS
,      OP_CODE
,      ORGN_CODE
,      QC_GRADE
,      REASON_CODE
,      TEXT_CODE
,      TRANS_DATE
,      TRANS_ID
,      TRANS_QTY
,      TRANS_QTY2
,      TRANS_STAT
,      TRANS_UM
,      TRANS_UM2
,      WHSE_CODE
FROM APPS.IC_TRAN_VW1;

Dependencies

[top of page]

APPS

IC_TRAN_CMP

IC_TRAN_PND

APPS

GMI_GMILTGEN_XMLP_PKG - show dependent code

GMI_LOTS_EVENT_V

OPI_DBI_INV_VALUE_OPM_INIT_PKG - show dependent code

OPI_EDW_OPMCOGS_F_C - show dependent code

PMITS_INV_LINE_SUMM_V

PMI_LOT_GENEALOGY_PKG - show dependent code

QC_TRAN_VW1

QC_TRAN_VW2