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

VIEW: GMF.CM_SCST_LED#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
RUDTL_ID NUMBER (10) Yes
STD_QTY NUMBER
Yes
FORM_PROD_UM VARCHAR2 (4)
ROUTING_QTY NUMBER
Yes
PRODUCT_QTY NUMBER
Yes
COST_ALLOC NUMBER (10) Yes
CMPNTCOST_ID NUMBER (10) Yes
ITEM_ID NUMBER (10)
LINE_TYPE NUMBER (10) Yes
ITEM_QTY NUMBER
Yes
ITEM_FMQTY NUMBER
Yes
ITEM_FMQTY_UM VARCHAR2 (4)
WHSE_CODE VARCHAR2 (4)
CMPNT_COST NUMBER
Yes
RESOURCES VARCHAR2 (16)
RESOURCE_COUNT NUMBER

RESOURCE_USAGE NUMBER

NOMINAL_COST NUMBER

USAGE_UM VARCHAR2 (4)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
DELETE_MARK NUMBER (5) Yes
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATED_BY NUMBER (15) Yes
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

FORM_PROD_UOM VARCHAR2 (3)
INVENTORY_ITEM_ID NUMBER (15)
ITEM_FMQTY_UOM VARCHAR2 (3)
ORGANIZATION_ID NUMBER (15)
USAGE_UOM VARCHAR2 (3)
Query Text

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


SELECT RUDTL_ID
,      STD_QTY
,      FORM_PROD_UM
,      ROUTING_QTY
,      PRODUCT_QTY
,      COST_ALLOC
,      CMPNTCOST_ID
,      ITEM_ID
,      LINE_TYPE
,      ITEM_QTY
,      ITEM_FMQTY
,      ITEM_FMQTY_UM
,      WHSE_CODE
,      CMPNT_COST
,      RESOURCES
,      RESOURCE_COUNT
,      RESOURCE_USAGE
,      NOMINAL_COST
,      USAGE_UM
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      DELETE_MARK
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      FORM_PROD_UOM
,      INVENTORY_ITEM_ID
,      ITEM_FMQTY_UOM
,      ORGANIZATION_ID
,      USAGE_UOM
FROM GMF.CM_SCST_LED#;

Dependencies

[top of page]

GMF.CM_SCST_LED# references the following:

SchemaGMF
TableCM_SCST_LED
GMF.CM_SCST_LED# is referenced by following:

SchemaAPPS
SynonymCM_SCST_LED