Skip to content

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

TABLE: MSC.MSC_CTO_SOURCES

Object Details
Object Name: MSC_CTO_SOURCES
Object Type: TABLE
Owner: MSC
Subobject Name:
Status: VALID


Tables contains line specific CTO option specific sources


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_CTO_SOURCES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSESSION_ID
ColumnLINE_ID
Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER
Yes Sales Order Line Id
ORGANIZATION_ID NUMBER

Organization Id
SUPPLIER_ID NUMBER

Supplier ID
SUPPLIER_SITE_CODE VARCHAR2 (30)
Supplier Site ID
STATUS_FLAG NUMBER

Staus Flag: 1-Current OSS Definition 2- Old OSS Definition
INVENTORY_ITEM_ID VARCHAR2 (240) Yes Source Inventory Item ID
SR_INSTANCE_ID NUMBER
Yes Source Instance ID
ATO_LINE_ID NUMBER
Yes ATO Line ID
CREATION_DATE DATE

Creation Date of Record
CREATED_BY NUMBER

ID of User who created the row
LAST_UPDATED_BY NUMBER

ID of Person who last updated the record
LAST_UPDATE_DATE DATE

Last Update Date
MAKE_FLAG VARCHAR2 (1)
This flag indicates whether model can be made in the organization or not
SESSION_ID NUMBER

Session Id of TAP inquiry
REFRESH_NUMBER NUMBER

Refresh number of the inquiry
PLAN_ID NUMBER

plan id against which line is processed.
Query Text

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


SELECT LINE_ID
,      ORGANIZATION_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_CODE
,      STATUS_FLAG
,      INVENTORY_ITEM_ID
,      SR_INSTANCE_ID
,      ATO_LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      MAKE_FLAG
,      SESSION_ID
,      REFRESH_NUMBER
,      PLAN_ID
FROM MSC.MSC_CTO_SOURCES;

Dependencies

[top of page]

MSC.MSC_CTO_SOURCES does not reference any database object

MSC.MSC_CTO_SOURCES is referenced by following:

SchemaMSC
ViewMSC_CTO_SOURCES#