MSC_INSTANCE_ORGSRC

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
SR_INSTANCE_ID ORGANIZATION_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN 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 ORGANIZATION_TYPE ERO_LRN IRO_LRN LAST_SUCC_IRO_REF_TIME LAST_SUCC_RES_REF_TIME ORGANIZATION_CODE ENABLE_ATP_WS DESCRIPTION

Name

SR_INSTANCE_ID

ORGANIZATION_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

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

ORGANIZATION_TYPE

ERO_LRN

IRO_LRN

LAST_SUCC_IRO_REF_TIME

LAST_SUCC_RES_REF_TIME

ORGANIZATION_CODE

ENABLE_ATP_WS

DESCRIPTION

Query

SQL_Statement
select "SR_INSTANCE_ID","ORGANIZATION_ID","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","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","ORGANIZATION_TYPE","ERO_LRN","IRO_LRN","LAST_SUCC_IRO_REF_TIME","LAST_SUCC_RES_REF_TIME","ORGANIZATION_CODE","ENABLE_ATP_WS","DESCRIPTION" from msc_instance_orgs as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))

SQL_Statement

select "SR_INSTANCE_ID","ORGANIZATION_ID","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","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","ORGANIZATION_TYPE","ERO_LRN","IRO_LRN","LAST_SUCC_IRO_REF_TIME","LAST_SUCC_RES_REF_TIME","ORGANIZATION_CODE","ENABLE_ATP_WS","DESCRIPTION" from msc_instance_orgs as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))