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

VIEW: MSC.MSC_SUP_LINES_INTERFACE#

Object Details
Object Name: MSC_SUP_LINES_INTERFACE#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PARENT_HEADER_ID NUMBER
Yes
LINE_ID NUMBER
Yes
QUANTITY NUMBER

UOM VARCHAR2 (30)
START_DATE VARCHAR2 (40)
END_DATE VARCHAR2 (40)
FORECAST_NAME VARCHAR2 (50)
LINE_NUMBER VARCHAR2 (10)
SUPLNSTATUS VARCHAR2 (20)
ITEM_NAME VARCHAR2 (240)
DESCRIPTION VARCHAR2 (240)
BUCKET_TYPE VARCHAR2 (15)
CUSTOMER_NAME VARCHAR2 (240)
CUSTOMER_ONETIME_FLAG VARCHAR2 (10)
CUSTOMER_SITE_ID VARCHAR2 (240)
SUPPLIER_NAME VARCHAR2 (240)
SUPPLIER_ONETIME_FLAG VARCHAR2 (10)
SUPPLIER_SITE_ID VARCHAR2 (240)
ERROR_MSG VARCHAR2 (240)
ROW_STATUS NUMBER

CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

Query Text

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


SELECT PARENT_HEADER_ID
,      LINE_ID
,      QUANTITY
,      UOM
,      START_DATE
,      END_DATE
,      FORECAST_NAME
,      LINE_NUMBER
,      SUPLNSTATUS
,      ITEM_NAME
,      DESCRIPTION
,      BUCKET_TYPE
,      CUSTOMER_NAME
,      CUSTOMER_ONETIME_FLAG
,      CUSTOMER_SITE_ID
,      SUPPLIER_NAME
,      SUPPLIER_ONETIME_FLAG
,      SUPPLIER_SITE_ID
,      ERROR_MSG
,      ROW_STATUS
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM MSC.MSC_SUP_LINES_INTERFACE#;

Dependencies

[top of page]

MSC.MSC_SUP_LINES_INTERFACE# references the following:

SchemaMSC
TableMSC_SUP_LINES_INTERFACE
MSC.MSC_SUP_LINES_INTERFACE# is referenced by following:

SchemaAPPS
SynonymMSC_SUP_LINES_INTERFACE