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

TABLE: MSC.MSC_INSTANCE_ORGS

Object Details
Object Name: MSC_INSTANCE_ORGS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_INSTANCE_ORGS
Subobject Name:
Status: VALID


This stores the information of the association links between each organization and MSC.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_INSTANCE_ORGS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnSR_INSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
SR_INSTANCE_ID NUMBER
Yes Source application instance identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ENABLED_FLAG NUMBER
Yes Yes/No flag indicating whether the instance org is enable
ORG_GROUP VARCHAR2 (30)
Org Group Identfier.
SUPPLIER_CAPACITY_LRN NUMBER

Last refresh number for entity Supplier Capacity.
BOM_LRN NUMBER

Last Refresh Number for entity BOM.
BOR_LRN NUMBER

Last Refresh Number for entity BOR
FORECAST_LRN NUMBER

Last Refresh Number for entity Forecast
ITEM_LRN NUMBER

Last Refresh Number for entity Item
MDS_LRN NUMBER

Last Refresh Number for entity MDS
MPS_LRN NUMBER

Last Refresh Number for entity MPS
OH_LRN NUMBER

Last Refresh Number for entity On Hand
RESERVATIONS_LRN NUMBER

Last Refresh Number for entity Reservations.
PO_LRN NUMBER

Last Refresh Numbers for entity PO
SO_LRN NUMBER

Last Refresh Number for entity SO.
USER_SUPPLY_DEMAND_LRN NUMBER

Last Refresh Number for entity User supply/Demand
WIP_LRN NUMBER

Last Refresh Number for entity WIP.
NRA_LRN NUMBER

Last Refresh Number for entity NRA.
SAF_STOCK_LRN NUMBER

Last Refresh Number for entity Safety Stock.
UNIT_NO_LRN NUMBER

Last Refresh Number for entity Unit Number
UOM_LRN NUMBER

Last Refresh Number for entity UOM
CALENDAR_LRN NUMBER

Last Refresh Number for entity Calendar.
TRIP_LRN NUMBER

Last refresh number for entity trip.
ORG_LRN NUMBER

Last refresh number for entity org.
DP_ENABLED_FLAG NUMBER

Yes/No flag indicating whether the instance org is Demand Planning enabled
LAST_SUCC_ASL_REF_TIME DATE

Last time asl successfully collected
LAST_SUCC_ITEM_REF_TIME DATE

Last time item successfully collected
ERO_LRN NUMBER

RN for External repair order
IRO_LRN NUMBER

RN of last successful collection of (Internal) Repair Order
LAST_SUCC_IRO_REF_TIME DATE

imestamp (src db generated) of last successful collection of IRO
LAST_SUCC_RES_REF_TIME DATE

Timestamp (src db generated) of begin of data pull in last successful collection of reservation
ORGANIZATION_TYPE NUMBER

Null/1 - Null, 2 - Field Technician,3 - Depot Repair,4 - External Repair
Query Text

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


SELECT SR_INSTANCE_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ENABLED_FLAG
,      ORG_GROUP
,      SUPPLIER_CAPACITY_LRN
,      BOM_LRN
,      BOR_LRN
,      FORECAST_LRN
,      ITEM_LRN
,      MDS_LRN
,      MPS_LRN
,      OH_LRN
,      RESERVATIONS_LRN
,      PO_LRN
,      SO_LRN
,      USER_SUPPLY_DEMAND_LRN
,      WIP_LRN
,      NRA_LRN
,      SAF_STOCK_LRN
,      UNIT_NO_LRN
,      UOM_LRN
,      CALENDAR_LRN
,      TRIP_LRN
,      ORG_LRN
,      DP_ENABLED_FLAG
,      LAST_SUCC_ASL_REF_TIME
,      LAST_SUCC_ITEM_REF_TIME
,      ERO_LRN
,      IRO_LRN
,      LAST_SUCC_IRO_REF_TIME
,      LAST_SUCC_RES_REF_TIME
,      ORGANIZATION_TYPE
FROM MSC.MSC_INSTANCE_ORGS;

Dependencies

[top of page]

MSC.MSC_INSTANCE_ORGS does not reference any database object

MSC.MSC_INSTANCE_ORGS is referenced by following:

SchemaAPPS
SynonymMSC_INSTANCE_ORGS