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

VIEW: GMF.GL_ITEM_CST#

Object Details
Object Name: GL_ITEM_CST#
Object Type: VIEW
Owner: GMF
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
FINAL_FLAG NUMBER (5) Yes
ORGN_CODE VARCHAR2 (4)
WHSE_CODE VARCHAR2 (4)
ITEM_ID NUMBER (10)
COST_MTHD_CODE VARCHAR2 (4)
END_DATE DATE
Yes
START_DATE DATE
Yes
CALENDAR_CODE VARCHAR2 (4)
PERIOD_CODE VARCHAR2 (4)
COST_TYPE NUMBER (5) Yes
ACCTG_COST NUMBER
Yes
FMEFF_ID NUMBER (10)
ITEMCOST_ID NUMBER (10) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
TRANS_CNT NUMBER (10)
DELETE_MARK NUMBER (5) Yes
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

COST_TYPE_ID NUMBER (15)
INVENTORY_ITEM_ID NUMBER (15)
ORGANIZATION_ID NUMBER (15)
PERIOD_ID NUMBER (15)
Query Text

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


SELECT FINAL_FLAG
,      ORGN_CODE
,      WHSE_CODE
,      ITEM_ID
,      COST_MTHD_CODE
,      END_DATE
,      START_DATE
,      CALENDAR_CODE
,      PERIOD_CODE
,      COST_TYPE
,      ACCTG_COST
,      FMEFF_ID
,      ITEMCOST_ID
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TRANS_CNT
,      DELETE_MARK
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      COST_TYPE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PERIOD_ID
FROM GMF.GL_ITEM_CST#;

Dependencies

[top of page]

GMF.GL_ITEM_CST# references the following:

SchemaGMF
TableGL_ITEM_CST
GMF.GL_ITEM_CST# is referenced by following:

SchemaAPPS
SynonymGL_ITEM_CST