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

VIEW: GMI.IC_ADJS_JNL#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANS_TYPE VARCHAR2 (4) Yes
TRANS_FLAG NUMBER (10) Yes
DOC_ID NUMBER (10) Yes
DOC_LINE NUMBER (10) Yes
JOURNAL_ID NUMBER (10) Yes
COMPLETED_IND NUMBER (5) Yes
WHSE_CODE VARCHAR2 (4)
REASON_CODE VARCHAR2 (4) Yes
DOC_DATE DATE
Yes
ITEM_ID NUMBER (10) Yes
ITEM_UM VARCHAR2 (4) Yes
ITEM_UM2 VARCHAR2 (4)
LOT_ID NUMBER (10)
LOCATION VARCHAR2 (16)
QTY NUMBER

QTY2 NUMBER

QC_GRADE VARCHAR2 (4)
LOT_STATUS VARCHAR2 (4)
LINE_TYPE NUMBER (5) Yes
LINE_ID NUMBER (10) Yes
CO_CODE VARCHAR2 (4)
ORGN_CODE VARCHAR2 (4) Yes
NO_INV NUMBER (5) Yes
NO_TRANS NUMBER (5)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
TRANS_CNT NUMBER (10)
LAST_UPDATED_BY NUMBER (15) Yes
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
ACCTG_UNIT_ID NUMBER

ACCT_ID NUMBER

TEXT_CODE NUMBER (10)
Query Text

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


SELECT TRANS_TYPE
,      TRANS_FLAG
,      DOC_ID
,      DOC_LINE
,      JOURNAL_ID
,      COMPLETED_IND
,      WHSE_CODE
,      REASON_CODE
,      DOC_DATE
,      ITEM_ID
,      ITEM_UM
,      ITEM_UM2
,      LOT_ID
,      LOCATION
,      QTY
,      QTY2
,      QC_GRADE
,      LOT_STATUS
,      LINE_TYPE
,      LINE_ID
,      CO_CODE
,      ORGN_CODE
,      NO_INV
,      NO_TRANS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      TRANS_CNT
,      LAST_UPDATED_BY
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      LAST_UPDATE_LOGIN
,      ACCTG_UNIT_ID
,      ACCT_ID
,      TEXT_CODE
FROM GMI.IC_ADJS_JNL#;

Dependencies

[top of page]

GMI.IC_ADJS_JNL# references the following:

SchemaGMI
TableIC_ADJS_JNL
GMI.IC_ADJS_JNL# is referenced by following:

SchemaAPPS
SynonymIC_ADJS_JNL