DBA Data[Home] [Help] [Dependency Information]

VIEW: GMI.IC_TRAN_PND#

Object Details
Object Name: IC_TRAN_PND#
Object Type: VIEW
Owner: GMI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANS_ID NUMBER (10) Yes
ITEM_ID NUMBER (10) Yes
LINE_ID NUMBER (10) Yes
CO_CODE VARCHAR2 (4) Yes
ORGN_CODE VARCHAR2 (4) Yes
WHSE_CODE VARCHAR2 (4) Yes
LOT_ID NUMBER (10) Yes
LOCATION VARCHAR2 (16) Yes
DOC_ID NUMBER (10) Yes
DOC_TYPE VARCHAR2 (4) Yes
DOC_LINE NUMBER (10) Yes
LINE_TYPE NUMBER (5) Yes
REASON_CODE VARCHAR2 (4)
CREATION_DATE DATE
Yes
TRANS_DATE DATE
Yes
TRANS_QTY NUMBER
Yes
TRANS_QTY2 NUMBER

QC_GRADE VARCHAR2 (4)
LOT_STATUS VARCHAR2 (4)
TRANS_STAT VARCHAR2 (4)
TRANS_UM VARCHAR2 (4) Yes
TRANS_UM2 VARCHAR2 (4)
OP_CODE NUMBER (15) Yes
COMPLETED_IND NUMBER (5) Yes
STAGED_IND NUMBER (5) Yes
GL_POSTED_IND NUMBER (10) Yes
EVENT_ID NUMBER (10) Yes
DELETE_MARK NUMBER (5) Yes
TEXT_CODE NUMBER (10)
LAST_UPDATE_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER (15)
REVERSE_ID NUMBER (10)
PICK_SLIP_NUMBER NUMBER

MVT_STAT_STATUS VARCHAR2 (30)
MOVEMENT_ID NUMBER

LINE_DETAIL_ID NUMBER

INVOICED_FLAG VARCHAR2 (1)
INTORDER_POSTED_IND NUMBER (5)
LOT_COSTED_IND NUMBER (5)
Query Text

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


SELECT TRANS_ID
,      ITEM_ID
,      LINE_ID
,      CO_CODE
,      ORGN_CODE
,      WHSE_CODE
,      LOT_ID
,      LOCATION
,      DOC_ID
,      DOC_TYPE
,      DOC_LINE
,      LINE_TYPE
,      REASON_CODE
,      CREATION_DATE
,      TRANS_DATE
,      TRANS_QTY
,      TRANS_QTY2
,      QC_GRADE
,      LOT_STATUS
,      TRANS_STAT
,      TRANS_UM
,      TRANS_UM2
,      OP_CODE
,      COMPLETED_IND
,      STAGED_IND
,      GL_POSTED_IND
,      EVENT_ID
,      DELETE_MARK
,      TEXT_CODE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      REVERSE_ID
,      PICK_SLIP_NUMBER
,      MVT_STAT_STATUS
,      MOVEMENT_ID
,      LINE_DETAIL_ID
,      INVOICED_FLAG
,      INTORDER_POSTED_IND
,      LOT_COSTED_IND
FROM GMI.IC_TRAN_PND#;

Dependencies

[top of page]

GMI.IC_TRAN_PND# references the following:

SchemaGMI
TableIC_TRAN_PND
GMI.IC_TRAN_PND# is referenced by following:

SchemaAPPS
SynonymIC_TRAN_PND