1/6/20 /2016
Ora Oracle Advan vanced ced Supply Cha Chain Plan lanning ing ( ASCP) CP) Tab Tables, les, Views iews | www.Ora www.Oracle cleA AppsQu sQuery.co ry.com m
(by Babu Chalamalasetti,To help Oracle community bridge the knowledge gaps.)
ABOU T
SCM
FINANC IALS
PROJECTS
CRM
HRMS
TECH NICAL
D BA
GET UPDATED!!
JOBS
MISC
Home » Home » Oracle Technical Useful » Useful » Oracle Apps Tables & Views » Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views Like 31 people like this. Be the first of your friends.
Useful Links All Modules Tables & Views
Oracle Advanced Supply Chain Planning ( AS CP) Tables, Views Tables, Views
Important Interfaces Useful Join Conditions Standard Reports List
ASCP Tables: TABLE N AME MSC_ MS C_AB ABC_ C_CL CLAS ASSE SES S
D ESCRIPTION This Th is ta tabl ble e de desc scri ribe bes s th the e cl clas assi sifi fica cati tion on of in inve vent ntor ory y go good ods s in into to cl clas ass s A, B, C class class types.
User login
MSC_ALLOC_DEMAND S This tabl table e desc describes ribes the tim time-ph e-phased ased allocation allocation rules
E-mail *
MSC_ALL MSC _ALLOCA OCATI TION_A ON_ASSI SSIGNM GNMENT ENTS S
This tabl table e desc describes ribes the alloc allocatio ation n assig assignment nments s
Password *
MSC_ MS C_AL ALLO LOCA CATI TION ON_R _RUL ULES ES
This Th is ta tabl ble e de desc scri ribe bes s th the e al allo loca cati tion on ru rule les s
MSC _A _AL LO LOC AT ATION S
Th is is ta bl bl e d es escri be be s th e al lo loc at ati on on s
M SC SC _A _A MO MON G_ G_ VA VAL UE UE S
U se se r s el el ec ec te te d c riri te te riri a fo r 1 0S 0S C P la la nn nn er er Wo rk rk be be nc nc h
MSC_ALL MSC _ALLOC_R OC_RULE_ ULE_TI TIME_P ME_PHAS HASES ES MSC_ALLOC_SUPPLIES
Log in using OpenID Create new account Request new password
MSC_ANALYSIS_AGGREGATE
Log in MSC_ANALYSIS_QUERY MSC_ANSWERS
Stores the Answers for Ask Oracle Questions
Live Visitors
MSC_APC C_ITEM_D MSC_A MS C_APP PPS_ S_INS INSTA TANCE NCES S
This Th is ta table bles s st store ores s th the e inf inform ormat ation ion of eac each h con connec necte ted d App Applic licat ation ion instance.
MSC_A MS C_ASS SSIG IGNME NMENT NT_S _SET ETS S
This Th is ta table ble st store ores s th the e ass assign ignme ment nt of sou sourc rcing ing rul rules es (o (orr bil bills ls of distribution) to item, organization, category, or at the global level.
MSC_ATP_DETAIL_PEG_TEMP M SC SC _A _A TP TP_ PA PAR AM AM ET ETE RS RS
A TP TP r el el at ate d p ar ar am am et ete rs rs s to to ra ra ge ge
MSC_ATP_PEG_TEMP MSC_ATP_PEGGING MSC_ATP_PLAN_SN M SC SC _A _A TP TP_ RU RU LE LE S
Th is is ta bl bl e s to to re re s r ul ul es es a nd nd o pt pti on on s th at at a re re u se se d i n A va va ilil ab ab le le To Promise computation.
MSC_ATP_SUMMARY_RES MSC_ATP_SUMMARY_SD MSC_ATP_SUMMARY_SO MSC_ATP_SUMMARY_SUP MSC_AV MSC _AVAIL AILABL ABLE_T E_TO_P O_PROM ROMIS ISE E
Available Avai lable to prom promise ise info informat rmation ion for mast master er sche scheduled duled part parts s
MSC_B MS C_BIL ILL_O L_OF_ F_RES RESOU OURCE RCES S
This Th is ta table ble st store ores s th the e set of res resour ources ces req requir uired ed in an org organi anizat zation ion..
http://w ww ww .o .or ac acl ea eappsquer y. y.com /? /?q= or or ac acl ee- ap apps- ad advanced- su suppl yy- ch chai nn- pl pl an anni ng ng- ta tabl es es- vi vi ew ew ss- as ascp
1/27
1/6/20 /2016
Ora Oracle Advan vanced ced Supply Cha Chain Plan lanning ing ( ASCP) CP) Tab Tables, les, Views iews | www.Ora www.Oracle cleA AppsQu sQuery.co ry.com m MSC_B MS C_BIS IS_BU _BUSI SINE NESS SS_PL _PLAN ANS S
A bus busine iness ss pla plan n in th this is con conte text xt is one of pos possib sibly ly man many y sc scena enari rios os which set performance targets to particular values anticipated under that scenario.
M SC SC _B _B IS IS_ IN IN V_ V_ CA CA T_ T_ MV MV _T _TA B
K PI PI Su mm mm ar ary Ta bl bl e
M SC SC _B _B IS IS_ IN IN V_ V_ DA DA TE TE _M _M V_ V_ TA TAB
K PI PI Su mm mm ar ary Ta bl bl e
MSC_ MS C_BI BIS_ S_IN INV_ V_DE DET TAI AIL L
MSC_ MS C_BI BIS_ S_IN INV_ V_DE DETA TAIL IL co cont ntai ains ns In Inve vent ntor ory y ba bala lanc nce e de deta tail ils s collected from source applications.
MSC_BIS_PERF MSC_BI S_PERFORMANCE ORMANCE_MEASURE _MEASURES S
MSC_BIS_PERF MSC_BI S_PERFORMANCE ORMANCE_MEAS _MEASURES URES contains business performance measures collected from source applications.
M SC SC _B _B IS IS_ PE PER IO IOD S
M SC SC _B _BIS _P _PE RI RIOD S s to to re re s p er er io io ds ds b et etw ee ee n th e c al al en en da da r s ta ta rt rt date and end dates.
MSC_ MS C_BI BIS_ S_RE RES_ S_DA DATE TE_M _MV_ V_T TAB
KPII Su KP Summ mmar ary y Tab able le
MSC_B MS C_BIS IS_RE _RES_ S_SUM SUMMA MARY RY
MSC_B MS C_BIS IS_RE _RES_ S_SUM SUMMA MARY RY st store ores s re resou sourc rce e req requir uired ed hou hours rs and available hours for BIS reports.
MSC_BI MSC _BIS_S S_SUPP UPPLIE LIER_SUM R_SUMMARY MARY
MSC_BI MSC_ BIS_S S_SUPPL UPPLIE IER_SUM R_SUMMARY MARY Sto Stores res BIS Supp Supplier lier Summ Summaruy aruy Entries
MSC_B MS C_BIS IS_T _TARG ARGET ET_LE _LEVE VELS LS
MSC_BIS MSC_B IS_T _TAR ARGE GET_ T_LE LEVE VELS LS con conta tains ins dif diffe fere rent nt com combin binat ation ions s of dimension levels to be applied simultaneously to get a performance indicator relevant to a particular reporting need. For example, if someone wants to know sales revenues broken down
MSC_ MS C_BI BIS_ S_TA TARG RGET ETS S
MSC_ MS C_BI BIS_ S_TA TARG RGET ETS S st stor ores es th the e ta targ rget et va valu lues es fo forr th the e BI BIS S re repo port rts. s.
MSC_B MS C_BOM OM_B _BOD OD_I _INT NTER ERFA FACE CE
Inte In terf rface ace ta table ble th that at con conta tains ins th the e BO BOM/ M/BO BOD D dat data a bef before ore val valida idati tion on
MSC_B MS C_BOM OM_CO _COMP MPON ONENT ENTS S
This Th is ta table ble st store ores s Bil Billl of mat mater erial ial dat data a fo forr pla plans ns in Or Oracl acle e Adv Advanc anced ed Planning and Oracle Supply Chain Hub products.
MSC_BOM_TEMP
BOM Temp Table
MSC _B _BOMS
Th is is ta bl bl e re pr pre se se nt nts th e Bi llll s Of Ma te te riri al al o f a n i te te m crea te te d a t source applications.
MSC_B MS C_BOR OR_RE _REQU QUIRE IREME MENT NTS S
This Th is ta table ble st store ores s th the e set of res resour ources ces req requir uired ed in an org organi anizat zation ion for an item.
MSC_BUDGETS_F MSC_CAL_ MSC _CAL_WE WEEK_ EK_ST START ART_DAT _DATES ES
This tabl table e sto stores res the work workday day calen calendar dar weekl weekly y sta start rt date dates s
MSC_C MS C_CAL_ AL_YE YEAR AR_ST _STAR ART_ T_DAT DATES ES
Work Wo rkday day cal calend endar ar yea yearly rly st start art dat dates es
MSC_ MS C_CA CALE LENDA NDAR_ R_DA DATE TES S
MSC_ MS C_CA CALE LEND NDAR AR_D _DAT ATES ES st stor ores es ev ever ery y da date te be betw twee een n th the e calendar start date and calendar end date for the given calendar using a specified exception set.This tables stores data collected from source applications.
MSC_CALE MSC _CALENDAR_ NDAR_EXCE EXCEPTI PTIONS ONS
MSC_CALE MSC_ CALENDAR_ NDAR_EXC EXCEPT EPTIO IONS NS sto stores res exce exceptio ption n date dates s for a calendar. You can define these exception dates to be working or non-working days. The workday calendar program uses this information to generate your workday calendar.
MSC _C _C AL AL EN EN DA DAR _S _SH IF IFTS
Wo rk rkd ay ay ca le le nd nd ar ar sh ififts
MSC _C _C AL AL EN EN DA DAR S
MSC _C _C AL ALEN DA DAR S sto re res th e de fifi ni ni titi on on o f yo ur ur w or orkd ay ay calendar.You can follow any of the four following type of quarters for your yearly calendar identified by Quarterly Calendar Type=1. 4-4-5 : quarterly pattern having two 4 weeks followedby
MSC_ MS C_CA CAPA PACI CITY TY_P _PLA LANS NS
MSC_C MS C_CAT ATEG EGOR ORY_ Y_SE SET_ T_ID ID_LI _LID D
MSC_CA MSC_ CAPA PACI CITY TY_P _PLA LANS NS is a ge gene neri ric c ta tabl ble e us used ed by fo form rms s fo for r querying data. This table is used to display capacity horizontal horizontal plan information in the Planner Workbench. QUERY_ID is the query identifier used while populating the table. The QUANT This ta This table ble is use used d by th the e col collec lecti tion on pro progra gram m to mai maint ntain ain th the e correspondence between the source instances identifiers and the planning identifiers for category sets.
MSC_ MS C_CA CATE TEGO GORY RY_S _SET ETS S
This Th is ta tabl bles es st stor ores es di diff ffer eren entt ca cate tego gory ry se sets ts fo forr an it item em..
MSC_C MS C_COL OLL_P L_PAR ARAM AMET ETERS ERS
Table Ta ble to St Store ore Col Collec lecti tion on Se Sessi ssion on Pa Param ramet eter er In Info form rmat ation ion
MSC _C _C OM OMPAN IE IES
C on on ta ta in in s l is is t o f co mp mp an an ie ie s i nv nvo lv lve d i n co llll ab ab or orati on on
MSC_ MS C_CO COMP MPAN ANY_ Y_ID ID_L _LID ID
Tabl Ta ble e wh whic ich h co cont ntai ains ns th the e li link nk be betw twee een n th the e co comp mpan any y id iden enti tifi fier er in the source ERP system and the company identifier generated in APS.
MSC_COM MSC _COMPAN PANY_RE Y_RELAT LATIO IONSHI NSHIPS PS
Table Tabl e to hold rela relation tionship ship betw between een comp companies anies for inte interent renterpr erprise ise collaboration and planning.
MSC_C MS C_COM OMPA PANY NY_SI _SITE TE_I _ID_L D_LID ID
This Th is ta table ble con conta tains ins th the e lin link k bet betwee ween n th the e com compan pany y sit site e ide ident ntif ifier ier in the source and thecompany site identifier generated in APS.
MSC_ MS C_CO COMP MPAN ANY_ Y_SI SITE TES S
This Th is ta tabl ble e co cont ntai ains ns th the e li list st of co comp mpan any y si site te us used ed in in inte tere rent nter erpr pris ise e collaboration and planning.
http://w ww ww .o .or ac acl ea eappsquer y. y.com /? /?q= or or ac acl ee- ap apps- ad advanced- su suppl yy- ch chai nn- pl pl an anni ng ng- ta tabl es es- vi vi ew ew ss- as ascp
Live Traffic Feed A visitor from Pune, Maharashtra viewed "Oracle "Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views A visitor | from Hyderabad, www.OracleAppsQuery.com" www.OracleAppsQuery.com Andhra Pradesh viewed "Oracle " Oracle " 38 Subledger secs agoAccounting (SLA) Tables, Views | www.OracleAppsQuery.com"" www.OracleAppsQuery.com A visitor from India viewed 49 secs ago "Oracle Human Resources ( HRMS )Tables, Views | www.OracleAppsQuery.com"" 1 www.OracleAppsQuery.com min A visitor ago from Thailand viewed "Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com" www.OracleAppsQuery.com A visitor from Mumbai, Mumbai , "2 Maharashtra mins ago viewed "Oracle "Oracle Installed Base Tables , Views | www.OracleAppsQuery.com"" 5 www.OracleAppsQuery.com mins ago A visitor from Hyderabad, Andhra Pradesh viewed "Oracle " Oracle iProcurement Tables, Views | www.OracleAppsQuery.com"" 6 www.OracleAppsQuery.com mins A visitor ago from Hyderabad, Andh Pradesh viewed "Join "Join between OE_ORDER_LINES_ALL and RA_CUSTOMER_TRX_LINES | www.OracleAppsQuery.com" www.OracleAppsQuery.com " 7 ago A visitor from Scottsdale, Arizona viewed "Oracle "Oracle Apps Receivables Data Flow and Data Model | www.OracleAppsQuery.com"" 7 www.OracleAppsQuery.com A visitor mins ago from Dubai viewed "Oracle Inventory Management ( INV ) Tables , Views | www.OracleAppsQuery.com"" 7 www.OracleAppsQuery.com mins A visitor ago from Santa Clara, California viewed "Oracle "Oracle Master Scheduling/MRP ( ASCP ) Tables, Views | " Real-time view · Get Feedjit
Recent content MOAC Setup ( Multi Org Access Control) oracleappsquery Oracle Diagnostic Toll oracleappsquery iExpenses Setup oracleappsquery AME Setups oracleappsquery Oracle Process Manufacturing oracleappsquery Cartonization Setup oracleappsquery MSCA: GUI forms and Navigation Path oracleappsquery WMS Forms and Navigation Paths oracleappsquery Dual UOM ( Unit of Measures) in Oracle oracleappsquery Import Repository Contracts oracleappsquery
2/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_COMPANY_USERS
This table contains the user company association for Oracle Collaborative planning functionality.
MSC_COMPONENT_SUBSTITUTES
This table represents possible substitutes component in a bill of material.
MSC_COSTS_F MSC_CRITERIA
Seeded criteria for Planner Workbench
M SC _C RITIC AL _P ATH S
Ta bl e c re at ed fo r Im pr ov ed E xc ep ti on s
MSC_CURRENCY_CONV_MV MSC_DELIVERY_DETAILS M SC _D EM AN D_ CL AS SE S
Th is ta bl e s to re s th e d em an d c la ss es .
MSC_DEMAND_MV_TAB
KPI Summary Table
M SC _D EM AN DS
Th is ta bl e s to re s a ll th e d ema nd s ta ke n i nto a cc ou nt fo r p la nn in g. Disposition_id would be a foreign key to MSC_SUPPLIES for dependent demands. For independent demands, disposition_id holds MRP_SCHEDULE_DATES.MPS_TRANSACTION_ID.
MSC_DEMANDS_CUM_F MSC_DEMANDS_F MSC_DEMANTRA_F MSC_DEPARTMENT_RESOURCES
This table stores the resources available for planning.
MSC_DESIGNATORS
This table stores MPS and MDS schedule names defined at source applications and planning server. MPS_RELIEF indicates whether or not the Planning Manager should consume this master demand or master production schedule..INVENTORY_ATP_FLAG in
MSC_DMD_SCN_METRICS MSC_DOC_ATTACHMENTS MSC_EAM_ACT_ASSOCIATIONS
This table Stores the Attachment information This table Stores the association relationship between an EAM Activty and the corresponding Asset/rebuildable item
MSC _EAM_ ASSET_ EQU IP_ DTL S MSC _ER ROR S
Sto res th e Errors th at h ave o ccu re d d uri ng th e pre -p ro ce ss ing . ERROR_ID is a unique identifier for each record. TABLE_NAME stores the staging table name in which the error occured. TRANSACTION_ID maps to ST_TRANSACTION_ID of the staging tab
MSC_EXC_DETAILS_ALL
This is an Exception Details table to be populated for Plan Comparison Reports.
MSC_EXCEPTION_DETAILS
This table stores the details of exceptions generated by Oracle Advanced Plannin g and Schedulin g(APS) and Oracle Supp ly Chain Hub products.
MSC_EXCEPTION_PREFERENCES
This table stores the order in which a user chooses to see the exception types.
MSC_EXCEPTION_THRESHOLD_VALUES
This table stores threshold values for each exception type. For supplier facing exceptions, the threshold values are obtained in the following order (specific to general):company_id, company_site_id, item, supplier_id, supplier_site_idcom
MSC_EXCEPTION_THRESHOLDS
This table is for storing the effective date of threshold defined for seeded and custom exceptions. This table is not used presently
MSC_EXCEPTIONS_F M SC _FC TI_ HE AD ER S_ IN TER FA CE MSC_FCTI_LINES_INTERFAC E MSC_FILES
File names used by the planner
MSC_FORECAST_UPDATES
This table describes the relationship between consumed forecast entries and sales order demands
M SC _FOR M_ QU ER Y
Te mp ora ra y ta bl e u se d i n c omp uta ti on o f r es ul ts i n Or ac le Advanced planni ng a nd Oracle Supply Chain Hub p roducts.
MSC_FULL_PEGGING
This table represents the pegging from supply to demands.
MSC_GANTT_QUERY MSC_GROUP_COMPANIES
This table stores membership information of various companies in different groups.
MSC _GR OU PS
Th is ta bl e sto re s i nfo rma ti on a bo ut g ro up s o f tra di ng p artn ers .
MSC_HUB_QUERY
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
3/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_IB_CONTRACTS_TEMP MSC_INST_PARTITIONS
This table stores the available and used instance partition information. Instance partitions are used to store the ODS data of specific instance.
MSC_INSTANCE_ORGS
This stores the information of the association links between each organization and MSC.
MSC_INT_1_E MSC_INT_10_E_SNO MSC_INT_10_TV MSC_INT_10_TV_SNO MSC_INT_11_E MSC_INT_11_E_SNO MSC_INT_11_TV MSC_INT_11_TV_SNO MSC_INT_12_E MSC_INT_12_E_SNO MSC_INT_12_TV_SNO MSC_INT_13_E MSC_INT_13_E_SNO MSC_INT_13_TV_SNO MSC_INT_14_E_SNO MSC_INT_14_TV_SNO MSC_INT_15_E_SNO MSC_INT_15_TV_SNO MSC_INT_16_E_SNO MSC_INT_16_TV_SNO MSC_INT_17_E_SNO MSC_INT_17_TV_SNO MSC_INT_18_E_SNO MSC_INT_18_TV_SNO MSC_INT_19_E_SNO MSC_INT_19_TV_SNO MSC_INT_2_E MSC_INT_20_E_SNO MSC_INT_20_TV_SNO MSC_INT_21_E_SNO MSC_INT_21_TV_SNO MSC_INT_22_E_SNO MSC_INT_22_TV_SNO MSC_INT_23_TV_SNO MSC_INT_24_E_SNO MSC_INT_24_MEM_SNO MSC_INT_25_E_SNO MSC_INT_25_TV_SNO MSC_INT_26_E_SNO MSC_INT_26_MEM_SNO MSC_INT_26_TV_SNO MSC_INT_27_E_PLAN MSC_INT_27_E_SNO MSC_INT_27_TV_SNO MSC_INT_28_MEM_SNO MSC_INT_28_TV_PLAN MSC_INT_28_TV_SNO
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
4/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_INT_29_E_PLAN MSC_INT_29_E_SNO MSC_INT_29_TV_SNO MSC_INT_3_TV MSC_INT_30_E_PLAN MSC_INT_30_TV_PLAN MSC_INT_30_TV_SNO MSC_INT_31_E_PLAN MSC_INT_31_E_SNO MSC_INT_31_MEM_SNO MSC_INT_32_E_PLAN MSC_INT_32_E_SNO MSC_INT_32_TV_PLAN MSC_INT_32_TV_SNO MSC_INT_33_E_PLAN MSC_INT_33_E_SNO MSC_INT_34_E_PLAN MSC_INT_34_E_SNO MSC_INT_34_TV_PLAN MSC_INT_34_TV_SNO MSC_INT_35_E_PLAN MSC_INT_35_MEM_SNO MSC_INT_36_E_PLAN MSC_INT_36_E_SNO MSC_INT_36_TV_PLAN MSC_INT_37_E_PLAN MSC_INT_37_TV_PLAN MSC_INT_37_TV_SNO MSC_INT_38_E_PLAN MSC_INT_39_E_PLAN MSC_INT_39_TV_PLAN MSC_INT_4_E MSC_INT_40_E_PLAN MSC_INT_41_E_PLAN MSC_INT_42_E_PLAN MSC_INT_43_E_PLAN MSC_INT_43_TV_PLAN MSC_INT_44_E_PLAN MSC_INT_45_E_PLAN MSC_INT_46_E_PLAN MSC_INT_47_E_PLAN MSC_INT_48_E_PLAN MSC_INT_49_E_PLAN MSC_INT_5_E MSC_INT_5_TV MSC_INT_50_E_PLAN MSC_INT_6_E MSC_INT_6_TV MSC_INT_7_TV MSC_INT_7_TV_SNO MSC_INT_8_E MSC_INT_8_E_SNO
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
5/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_INT_8_TV MSC_INT_9_E MSC_INT_9_TV MSC_INT_9_TV_SNO MSC_INT_ACTUAL_RES_HRS MSC_INT_ACTUAL_RESOURCE_PLAN MSC_IN T_ALL_DEMAN D_ITEM MSC_INT_ALL_ITEM MSC_INT_ALL_SUPPLY_ITEM MSC_INT_ALT_RES MSC _IN T_ APC C_ ITEM_ SOU RC E MSC_IN T_APC C_ORG_DETAIL MSC_INT_ASCP_DEMANDS MSC_INT_ASCP_DEPENDENT_DEMAND MSC_INT_ASCP_END_ITEM MSC_INT_ASCP_EXCEPTION_DETAILS MSC_INT_ASCP_EXPORT_BUCKETS MSC_INT_ASCP_INVENTORY MSC_INT_ASCP_KPI MSC_IN T_ASC P_LABOUR_UTIL MSC _IN T_ ASC P_ MAC HIN E_U TIL MSC_INT_ASCP_MFG_PLAN_LABOUR MSC_INT_ASCP_MFG_PLAN_MACHINE M SC _IN T_ ASC P_ PR OD COST_ KP I MSC_INT_ASCP_SUPPLY MSC_IN T_ASC P_SU PPLY_ITEM MSC_INT_ASCP_TOTALPRODCOST MSC_INT_ASCP_TRANSPCOST_KPI MSC_INT_ASCP_TRANSPORTATION MSC_INT_ASSET M SC _IN T_ ASS IGN ED _ATTR IB UTE MSC_INT_ATTRIBUTE_VALUE MSC_INT_BEGINNING_INVENTORY MSC_INT_BOR_RES_NAME MSC_INT_BRANCH MSC_INT_BRANCH_GROUP MSC _IN T_ BR AN CH _GR OU P_ MEM MSC _IN T_ BR AN CH _OPER ATION MSC_INT_BRANCH_OPERATION_SET MSC_INT_BRANCH_OPERATION_SNO MSC_INT_BRANCH_OPERATION_TV MSC_INT_BRANCH_ROUTING M SC _IN T_ BR AN CH _R OU TIN G_ SN O M SC _IN T_ BR AN CH _R OU TIN G_ TV MSC_INT_BRANCH_ROUTING_TV_SNO MSC_INT_BRANCH_SNO MSC_INT_CALENDAR MSC_INT_CALENDAR_SNO MSC_INT_CALENDAR_TV MSC_IN T_CALEN DAR _TV_SNO MSC_INT_CFC_SCENARIO_DETAILS MSC_INT_CHANGEOVER_PATTERN
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
6/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_INT_CHANGEOVER_PATTERN_SNO MSC_INT_CMRO_OP_REL MSC_INT_CMRO_RES_REQS MSC_INT_COMPONENT_ITEM M SC _IN T_ CON SU MED _ITE M_ BOM MSC_INT_CONSUMED_ITEM_BOM_SNO MSC_INT_CONSUMED_ITEM_BOM_TV M SC _IN T_ CON SU MED _ITE M_ SET MSC_INT_CONSUMED_ITEM_SET_SNO MSC_INT_CREW MSC_INT_CREW_SNO MSC_INT_CREW_TV MSC_INT_CREW_TV_SNO M SC _IN T_ CU ST_ ITEM _TR _M OD E MSC_INT_CUST_ITEM_TR_MODE_SNO MSC_INT_CUST_ITEM_TR_MODE_TV MSC_INT_CUST_TR_MODE MSC _IN T_ CU ST_ TR _MOD E_SN O MSC_IN T_CU ST_TR_MODE_TV MSC_INT_CUST_TR_MODE_TV_SNO MSC_INT_CUSTOMER MSC_IN T_CU STOMER_GROU P MSC_INT_CUSTOMER_GROUP_MEM MSC_INT_CUSTOMER_GROUP_MEM_SNO MSC_INT_CUSTOMER_GROUP_SNO MSC_INT_CUSTOMER_SNO M SC _IN T_ CU STOM ER _SOU RC IN G MSC_INT_CUSTOMER_SOURCING_SNO MSC_INT_CUSTOMER_SOURCING_TV MSC_INT_END_ITEM MSC_INT_ENT_FCST_DETAIL MSC_INT_ENT_FCST_DETAIL_SNO M SC _IN T_ EN T_ FC ST_ DE TAIL _TV MSC_INT_ENT_FCST_DETAIL_TV_SNO MSC_INT_ENTERPRISE_FORECAST MSC_INT_EQUIPMENT MSC_INT_FIXED_PRODUCTION_SNO MSC_INT_IMPL_RES MSC_IN T_IMPLEMENTING_RES MSC_INT_IMPLEMENTING_RES_SNO MSC_INT_IMPLEMENTING_RES_TV MSC_INT_IMPLEMENTING_RESOURCE MSC_INT_INV_SAFE_TAR M SC _IN T_ IN V_ SA FE_ TA R_ DETA IL MSC_INT_INV_SAFE_TAR_DETAIL_TV MSC_IN T_IN V_SAFE_TAR_SNO MSC_IN T_IN VENTORY_POLICY MSC_INT_INVENTORY_POLICY_SNO MSC_INT_INVENTORY_POLICY_TV MSC_INT_ITEM MSC_INT_ITEM_BRANCH MSC_IN T_ITEM_BRANCH_SNO
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
7/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_INT_ITEM_BRANCH_TV M SC _IN T_ ITE M_ BR AN CH _TV _S NO MSC_INT_ITEM_GROUP MSC_INT_ITEM_GROUP_MEM MSC_INT_ITEM_GROUP_MEM_SNO MSC_INT_ITEM_GROUP_SNO MSC_INT_ITEM_PRICE MSC_INT_ITEM_PRICE_SNO MSC_INT_ITEM_PRICE_TV MSC _IN T_ ITEM_PR IC E_ TV_ SN O MSC_INT_ITEM_SNO MSC_INT_ITEM_STORAGE MSC _IN T_ ITEM_STOR AGE_SN O MSC_IN T_ITEM_STORAGE_TV MSC_INT_ITEM_STORAGE_TV_SNO MSC_INT_ITEM_TRANSPORT_MODE MSC_INT_ITEM_TRAVEL_DISTANCE MSC_INT_ITEM_UOM MSC_INT_ITEM_UOM_SNO MSC_INT_JOB_ALT_RES MSC_INT_LANE MSC_INT_LANE_SNO MSC_INT_MACH_ATTRIBUTE MSC_INT_MACHINE MSC_INT_MACHINE_SNO MSC_INT_MACHINE_TV MSC_INT_MACHINE_TV_SNO MSC _IN T_ NEXT_ WOR K_ OR DER MSC_INT_OPERATION MSC_INT_OPERATION_BOR M SC _IN T_ OP ER ATION _B OR _S NO MSC _IN T_ OPER ATION _BOR _TV MSC_INT_OPERATION_BOR_TV_SNO MSC_IN T_OPERATION _GROUP MSC_INT_OPERATION_GROUP_MEM MSC_INT_OPERATION_GROUP_SNO MSC_INT_OPERATION_SET M SC _IN T_ OP ER ATION _S ET_ ME M MSC_INT_OPERATION_SET_MEM_SNO M SC _IN T_ OP ER ATION _S ET_ SN O MSC_INT_OPERATION_SNO MSC_INT_OSFM_PATH MSC_INT_PEGGED_WORK_ORDER_PLAN MSC_INT_PRODUCED_ITEM M SC _IN T_ PR OD UC ED _I TE M_ BOM MSC_INT_PRODUCED_ITEM_BOM_SNO MSC_INT_PRODUCED_ITEM_BOM_TV M SC _IN T_ PR OD UC ED _I TE M_ SN O MSC_INT_PS_ALL_ITEM MSC_INT_PS_DEMAND_ITEM MSC_INT_PS_END_ITEM MSC_INT_PS_SUPPLY_ITEM
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
8/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_INT_PURCHASE_ORDER MSC_INT_PURCHASE_ORDER_DETAIL MSC_INT_PURCHASE_ORDER_SNO MSC_INT_RESERVATION M SC _IN T_ RE SOU RC E_ ATTR IB UTE MSC_IN T_RESOURCE_GROU P MSC_INT_RESOURCE_GROUP_MEM MSC_INT_RESOURCE_GROUP_MEM_SNO MSC_INT_RESOURCE_GROUP_SNO MSC_INT_RESOURCE_PLAN MSC_INT_RESOURCE_SCHEDULE_PLAN MSC_INT_RESOURCE_SET MSC _IN T_ RESOU RC E_ SET_SN O MSC_INT_ROUTING MSC_INT_ROUTING_SNO MSC_INT_SALES_ORDER M SC _IN T_ SAL ES_ OR DER _D ETAIL MSC_INT_SALES_SNO MSC_INT_SALES_TV_SNO MSC_INT_SATISFIED_DEMAND_PLAN M SC _IN T_ SC HE DU LE _B OR _P LAN M SC _IN T_ SC HE DU LE _M IL ESTON E MSC _IN T_ SC HED UL E_OP_ PL AN MSC_INT_SHIFT_CALENDAR MSC _IN T_ SOU RC E_ ITEM_ PL AN MSC_INT_SOURCE1 MSC_INT_SOURCE2 MSC_INT_SRC_RECOMMEND_DETAIL MSC_INT_STANDARD_UOM MSC _IN T_ STAN DAR D_U OM_ SN O MSC_INT_STORAGE MSC_INT_STORAGE_SNO MSC_INT_STORAGE_TV MSC_INT_STORAGE_TV_SNO MSC_INT_SUB_COMPONENT_ITEM MSC_INT_SUPPLIER MSC_INT_SUPPLIER_GROUP MSC_INT_SUPPLIER_GROUP_MEM MSC_INT_SUPPLIER_GROUP_MEM_SNO M SC _IN T_ SU PPL IER _GR OU P_ SN O MSC_INT_SUPPLIER_ITEM MSC_INT_SUPPLIER_ITEM_BRANCH MSC _IN T_ SU PPL IER _ITEM_ SN O MSC_IN T_SUPPLIER _ITEM_TV MSC_INT_SUPPLIER_ITEM_TV_SNO MSC_INT_SUPPLIER_SNO MSC_IN T_SUPPLY_END_ITEM M SC _IN T_ TE MPOR AL _R EL ATION MSC_INT_TEMPORAL_RELATION_SNO MSC_INT_TOOL MSC_INT_TOOL_SNO MSC_INT_TOOL_TV
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
9/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_INT_TOOL_TV_SNO MSC_INT_TRANSFER_ORDER MSC_INT_TRANSFER_ORDER_DETAIL MSC _IN T_ TR AN SFER _OR DER _IN MSC_INT_TRANSFER_ORDER_OUT MSC_INT_TRANSFER_ORDER_SNO MSC_INT_TRANSPORT_MODE MSC_INT_TRANSPORT_MODE_SNO M SC _IN T_ TR AN SPOR T_ MOD E_ TV MSC_INT_TRANSPORT_MODE_TV_SNO MSC_INT_VISIT MSC_INT_WO_CMRO_CONFIG MSC_INT_WO_CONSUMED_ITEM_BOM MSC _IN T_ WO_ OPER ATION _SET MSC_INT_WO_PRODUCED_ITEM_BOM MSC_IN T_WO_TEMPORAL_R EL MSC_INT_WORK_ORDER MSC_IN T_WORK_ORDER_BOR MSC_INT_WORK_ORDER_BOR_SNO MSC_INT_WORK_ORDER_IMP_RES MSC_INT_WORK_ORDER_OPERATION MSC_IN T_WORK_ORDER_SN O MSC_INTERORG_SHIP_METHODS
This table stores the different shipment methods and their availability.
MSC_ITEM_CATEGORIES
This table stores the item assignment to categories within a category set.
MSC_ITEM_CUSTOMERS
Table to hold customer items and cross references.
MSC_ITEM_EXCEPTIONS
This table stores a row per exception message against an item for exceptions generated in the Oracle Advanced planning and scheduli ng (APS) and the Oracle Supply Chain Hub products.
MSC_ITEM_HIERARCHY_MV M SC _ITE M_ ID _L ID
Th is ta bl e i s u se d b y th e c ol le cti on p ro gr am to m ai nta in t he correspondence between the source instances identifiers and the planning identifiers for items.
MSC_ITEM_INVENTORY_F MSC_ITEM_KPI_F MSC_ITEM_ORDERS_F MSC_ITEM_SOURCING
This table stores sourcing information for an item used in Oracle Advanced Plannin g and Schedulin g. This table is al so use d to store Sourcing information for in line vehicle sequencing (ILVS) in the Supply Chain Hub product.
MSC_ITEM_SUBSTITUTES
This table stores all the Relationships between Item Substitutes for planning.
MSC_ITEM_SUPPLIERS
This table stores the processing lead time, order modifier, and delivery calendar information for each item - supplier/site.
MSC_ITEM_WIPS_F MSC _ITEMS
Th is ta bl e i s u se d b y th e co ll ecti on p rog ra m to ke ep tra ck o f a ll inventory item identifiers generated at planning server.
MSC_ITEMS_F MSC_ITG_1_E MSC_ITG_10_E_SNO MSC_ITG_11_TV_SNO MSC_ITG_12_E_SNO MSC_ITG_13_TV_SNO MSC_ITG_14_E_SNO MSC_ITG_15_E_SNO MSC_ITG_16_TV_SNO
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
10/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_ITG_17_E_SNO MSC_ITG_18_TV_SNO MSC_ITG_19_TV_SNO MSC_ITG_2_E MSC_ITG_20_TV_SNO MSC_ITG_21_TV_SNO MSC_ITG_22_E_SNO MSC_ITG_23_TV_SNO MSC_ITG_24_MEM_SNO MSC_ITG_25_E_SNO MSC_ITG_26_TV_SNO MSC_ITG_27_E_PLAN MSC_ITG_28_TV_PLAN MSC_ITG_29_E_PLAN MSC_ITG_3_TV MSC_ITG_30_E_PLAN MSC_ITG_31_E_PLAN MSC_ITG_32_TV_PLAN MSC_ITG_33_E_PLAN MSC_ITG_34_E_PLAN MSC_ITG_35_E_PLAN MSC_ITG_36_E_PLAN MSC_ITG_37_E_PLAN MSC_ITG_38_E_PLAN MSC_ITG_39_E_PLAN MSC_ITG_4_E MSC_ITG_5_TV MSC_ITG_6_TV MSC_ITG_7_TV_SNO MSC_ITG_8_E_SNO MSC_ITG_9_TV_SNO MSC_ITG_ACTUAL_RES_HRS MSC_ITG_ACTUAL_RESOURCE_PLAN MSC_ITG_ALT_RES MSC_ITG_ASCP_END_ITEM MSC _ITG_ ASC P_ SU PPL Y_ ITEM MSC_ITG_ASSET M SC _ITG_ ASS IGN ED _ATTR IB UTE MSC_ITG_ATTR IBUTE_VALUE MSC_ITG_BEGINNING_INVENTORY MSC_ITG_BOR_RES_NAME MSC_ITG_BRANCH MSC_ITG_BRANCH_GROUP M SC _ITG_ BR AN CH _GR OU P_ ME M MSC _ITG_ BR AN CH _OPER ATION MSC_ITG_BRANCH_OPERATION_SET MSC_ITG_BRANCH_OPERATION_SNO MSC_ITG_BRANCH_OPERATION_TV MSC_ITG_BRANCH_ROUTING MSC_ITG_BRANCH_ROUTING_SNO M SC _ITG_ BR AN CH _R OU TIN G_ TV MSC_ITG_BRANCH_ROUTING_TV_SNO
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
11/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_ITG_BRANCH_SNO MSC_ITG_CALENDAR MSC_ITG_CALENDAR_SNO MSC_ITG_CALENDAR_TV MSC_ITG_CALEN DAR _TV_SNO MSC_ITG_CFC_SCENARIO_DETAILS MSC_ITG_CHANGEOVER_PATTERN MSC_ITG_CHANGEOVER_PATTERN_SNO MSC_ITG_CMRO_OP_REL MSC_ITG_CMRO_RES_REQS MSC_ITG_COMPONENT_ITEM M SC _ITG_ CON SU MED _ITE M_ BOM MSC_ITG_CONSUMED_ITEM_BOM_SNO MSC_ITG_CONSUMED_ITEM_BOM_TV M SC _ITG_ CON SU MED _ITE M_ SET MSC_ITG_CONSUMED_ITEM_SET_SNO MSC_ITG_CREW MSC_ITG_CREW_SNO MSC_ITG_CREW_TV MSC_ITG_CREW_TV_SNO M SC _ITG_ CU ST_ ITEM _TR _M OD E MSC_ITG_CUST_ITEM_TR_MODE_SNO MSC_ITG_CUST_ITEM_TR_MODE_TV MSC_ITG_CUST_TR_MODE MSC _ITG_ CU ST_ TR _MOD E_SN O MSC_ITG_CU ST_TR_MODE_TV MSC_ITG_CUST_TR_MODE_TV_SNO MSC_ITG_CUSTOMER MSC_ITG_CU STOMER_GROU P MSC_ITG_CUSTOMER_GROUP_MEM MSC_ITG_CUSTOMER_GROUP_MEM_SNO MSC_ITG_CUSTOMER_GROUP_SNO MSC_ITG_CUSTOMER_SNO MSC_ITG_END_ITEM MSC_ITG_ENT_FCST_DETAIL MSC_ITG_ENT_FCST_DETAIL_SNO M SC _ITG_ EN T_ FC ST_ DE TAIL _TV MSC_ITG_ENT_FCST_DETAIL_TV_SNO MSC_ITG_ENTERPRISE_FORECAST MSC_ITG_EQUIPMENT MSC_ITG_FIXED_PRODUCTION_SNO MSC_ITG_IMPL_RES MSC _ITG_ IMPL EMEN TIN G_ RES MSC_ITG_IMPLEMENTING_RES_SNO MSC_ITG_IMPLEMENTING_RES_TV MSC_ITG_INV_SAFE_TAR M SC _ITG_ IN V_ SA FE_ TA R_ DETA IL MSC_ITG_INV_SAFE_TAR_DETAIL_TV MSC _ITG_ IN V_ SAFE_ TAR _SN O MSC_ITG_IN VENTORY_POLICY MSC_ITG_INVENTORY_POLICY_SNO MSC_ITG_INVENTORY_POLICY_TV
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
12/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_ITG_ITEM MSC_ITG_ITEM_BRANCH MSC_ITG_ITEM_BRANCH_SNO MSC_ITG_ITEM_BRANCH_TV M SC _ITG_ ITE M_ BR AN CH _TV _S NO MSC_ITG_ITEM_GROUP MSC_ITG_ITEM_GROUP_MEM MSC_ITG_ITEM_GROUP_MEM_SNO MSC_ITG_ITEM_GROUP_SNO MSC_ITG_ITEM_PRICE MSC_ITG_ITEM_PRICE_SNO MSC_ITG_ITEM_PRICE_TV MSC _ITG_ ITEM_PR IC E_ TV_ SN O MSC_ITG_ITEM_SNO MSC_ITG_ITEM_STORAGE MSC _ITG_ ITEM_STOR AGE_SN O MSC_ITG_ITEM_STORAGE_TV MSC_ITG_ITEM_STORAGE_TV_SNO MSC_ITG_ITEM_TRANSPORT_MODE MSC_ITG_ITEM_UOM MSC_ITG_ITEM_UOM_SNO MSC_ITG_JOB_ALT_RES MSC_ITG_LANE MSC_ITG_LANE_SNO MSC_ITG_MACH_ATTRIBUTE MSC_ITG_MACHINE MSC_ITG_MACHINE_SNO MSC_ITG_MACHINE_TV MSC_ITG_MACHINE_TV_SNO MSC _ITG_ NEXT_ WOR K_ OR DER MSC_ITG_OPERATION MSC_ITG_OPERATION_BOR M SC _ITG_ OP ER ATION _B OR _S NO MSC _ITG_ OPER ATION _BOR _TV MSC_ITG_OPERATION_BOR_TV_SNO MSC_ITG_OPERATION _GROUP MSC_ITG_OPERATION_GROUP_MEM MSC_ITG_OPERATION_GROUP_SNO MSC_ITG_OPERATION_SET M SC _ITG_ OP ER ATION _S ET_ ME M MSC_ITG_OPERATION_SET_MEM_SNO M SC _ITG_ OP ER ATION _S ET_ SN O MSC_ITG_OPERATION_SNO MSC_ITG_OSFM_PATH MSC_ITG_PEGGED_WORK_ORDER_PLAN MSC_ITG_PRODUCED_ITEM M SC _ITG_ PR OD UC ED _I TE M_ BOM MSC_ITG_PRODUCED_ITEM_BOM_SNO MSC_ITG_PRODUCED_ITEM_BOM_TV M SC _ITG_ PR OD UC ED _I TE M_ SN O MSC_ITG_PS_ALL_ITEM MSC_ITG_PS_DEMAND_ITEM
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
13/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_ITG_PS_END_ITEM MSC_ITG_PS_SUPPLY_ITEM MSC_ITG_PURCHASE_ORDER MSC_ITG_PURCHASE_ORDER_DETAIL MSC_ITG_PURCHASE_ORDER_SNO MSC_ITG_RES_IN TERMEDIATE MSC_ITG_RESERVATION M SC _ITG_ RE SOU RC E_ ATTR IB UTE MSC_ITG_RESOURCE_GROU P MSC_ITG_RESOURCE_GROUP_MEM MSC_ITG_RESOURCE_GROUP_MEM_SNO MSC_ITG_RESOURCE_GROUP_SNO MSC_ITG_RESOURCE_PLAN MSC_ITG_RESOURCE_SCHEDULE_PLAN MSC_ITG_RESOURCE_SET MSC _ITG_ RESOU RC E_ SET_SN O MSC_ITG_ROUTING MSC_ITG_ROUTING_SNO MSC_ITG_SALES_ORDER M SC _ITG_ SAL ES_ OR DER _D ETAIL MSC_ITG_SALES_SNO MSC_ITG_SALES_TV_SNO MSC_ITG_SATISFIED_DEMAND_PLAN M SC _ITG_ SC HE DU LE _B OR _P LAN M SC _ITG_ SC HE DU LE _M IL ESTON E MSC_ITG_SHIFT_CALENDAR MSC _ITG_ SOU RC E_ ITEM_ PL AN MSC_ITG_STANDARD_UOM MSC _ITG_ STAN DAR D_U OM_ SN O MSC_ITG_STORAGE MSC_ITG_STORAGE_SNO MSC_ITG_STORAGE_TV MSC_ITG_STORAGE_TV_SNO MSC_ITG_SUB_COMPONENT_ITEM MSC_ITG_SUPPLIER MSC_ITG_SUPPLIER_GROUP MSC_ITG_SUPPLIER_GROUP_MEM MSC_ITG_SUPPLIER_GROUP_MEM_SNO MSC_ITG_SUPPLIER_GROUP_SNO MSC_ITG_SUPPLIER_ITEM MSC_ITG_SUPPLIER_ITEM_BRANCH MSC _ITG_ SU PPL IER _ITEM_ SN O MSC_ITG_SUPPLIER _ITEM_TV MSC_ITG_SUPPLIER_ITEM_TV_SNO MSC_ITG_SUPPLIER_SNO M SC _ITG_ TE MPOR AL _R EL ATION MSC_ITG_TEMPORAL_RELATION_SNO MSC_ITG_TOOL MSC_ITG_TOOL_SNO MSC_ITG_TOOL_TV MSC_ITG_TOOL_TV_SNO MSC_ITG_TRANSFER_ORDER
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
14/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_ITG_TRANSFER_ORDER_DETAIL M SC _ITG_ TR AN SFE R_ OR DER _IN MSC_ITG_TRANSFER_ORDER_OUT MSC_ITG_TRANSFER_ORDER_SNO MSC_ITG_TRANSPOR T_MOD E MSC_ITG_TRANSPORT_MODE_SNO M SC _ITG_ TR AN SPOR T_ MOD E_ TV MSC_ITG_TRANSPORT_MODE_TV_SNO MSC_ITG_VISIT MSC_ITG_WO_CMRO_C ONFIG MSC_ITG_WO_CONSUMED_ITEM_BOM MSC _ITG_ WO_ OPER ATION _SET MSC_ITG_WO_PRODUCED_ITEM_BOM MSC_ITG_WO_TEMPORAL_R EL MSC_ITG_WORK_ORDER MSC_ITG_WORK_ORDER_BOR MSC_ITG_WORK_ORDER_IMP_RES MSC_ITG_WORK_ORDER_OPERATION MSC _JOB_ OP_ RES_ IN STAN CES MSC_JOB_OP_RESOURCES MSC_JOB_OPERATION_NETWORKS MSC_JOB_OPERATIONS MSC_JOB_REQUIREMEN T_OPS M SC _L ATE _OR DE R_ MV _TA B
K PI Su mm ary Ta bl e
MSC_LOCAL_ID_DEMAND
MSC_LOCAL_ID_DEMAND table stores the mappings between the Local IDs and the User Defined Keys for all types of Demands. The table is striped by ENTITY_NAME.
MSC_LOCAL_ID_ITEM
MSC_LOCAL_ID_ITEM table stores the mappings between the Local IDs and the User Defined Keys for Items. The table is striped by ENTITY_NAME. The entities and their mappings with staging table columns are listed below.ENTITY_NAME: SR_INVENTOR
MSC_LOCAL_ID_MISC
MSC_LOCAL_ID_MISC table stores the mappings between the Local IDs and the User Defined Keys for Sourcing Rules, Projects, Tasks and Categories. The table is striped by ENTITY_NAME.
MSC_LOCAL_ID_SETUP
MSC_LOCAL_ID_SETUP table stores the mappings between the Local IDs and the User Defined Keys for BOM, Routing, Trading Partners, Departments, Resources and Calendars. The table is striped by ENTITY_NAME.
MSC_LOCAL_ID_SUPPLY
MSC_LOCAL_ID_SUPPLY This table stores the mappings between the Local IDs and the User Defined Keys for all the Supplies. The table is striped by ENTITY_NAME.
MSC_LOCATION_ASSOCIATIONS
This table stores location associations for organization, customer, customer sites, supplier, and supplier sites.
MSC_LON G_TEXT
This table Stores the Short text Content
MSC_MATERIAL_PLANS
MSC_MATERIAL_PLANS is a generic table used by forms for querying data.
MSC_MTH_OPEN_SALES_ORDERS_F MSC_NEC_COMPARE_PLANS
This table store the the status of the plan which has launched the "Compare Plan Exceptions" concurrent program.
MSC_NEC_EXC_DTL_COMPARE
This table is a working table for Plan Comparison Reports.
MSC_NET_CHANGE_CRITERIA
This table stores the criteria used in Plan Comparison Reports.
MSC_NET_RES_INST_AVAIL MSC_NET_RESOURCE_AVAIL
This table stores the resource availability profile of the different resources.
MSC_OE_DATA_TEMP MSC_OPERATION_COMPONENTS
This table is the intersection table between MSC_BOM_COMPONENTS and MSC_ROUTING_OPERATIONS.
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
15/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_OPERATION_NETWORKS
This table is a child table of msc_operations. Describes the network structure of operations of a network routing.
MSC_OPERATION_RESOURCE_SEQS
This tables stores the operation resources for each routing operation.
MSC_OPERATION_RESOURCES
This table stores operation resources from a resource sequence. For each resource sequence, we have an alternative between different set of operation resources. This is described by the Alternate N umber. Resources with the same Altern ate
MSC_ORG_ACCESS
This table stores the organizations to which a responsibility has access
M SC _OR G_ AGGR _IBU C
Th is ta bl e S to re s th e a gg re ga te d q ua nti ty of the install base item instances at item,date,org level
MSC_ORP_MATERIAL_PLANS MSC_OR P_RESOURCE_PLAN S MSC_OUTBOUND_ENTRIES
Outbound XML transactions from Collaborative Planning
M SC _P AR AM ETE RS
Th is ta bl e s to re s i nfo rma ti on a bo ut h ow th e p la nn in g p ro ce ss works for a given organization. Each organization will have an entry in MSC_PARAMETERS if it is using planning.
MSC_PART_DEMANDS MSC_PART_PEGGING MSC_PART_SUPPLIES MSC_PARTNER_CONTACTS
This table stores the partner contacts.
MSC_PDR_PARAMETERS
Store the parameters user entered in the Planning Detailed Reports
MSC_PDR_PARAMETERS_NEW
Store the parameters user entered in the Planning Detailed Reports
MSC_PERIOD_START_DATES
Workday calendar period start dates
MSC_PHUB_CATEGORIES_MV MSC_PHUB_CUSTOMERS_MV MSC_PHUB_DATES_MV MSC_PHUB_ITEM_CATEGORIES_MV M SC _P HU B_ MFG_ CAL _D ATE S_ MV MSC_PHUB_ORGS_MV MSC_PHUB_PROJECTS_MV MSC_PHUB_RESOURCES_MV MSC_PHUB_SUPPLIERS_MV MSC_PLAN_BUCKETS
This table stores bucket dates for Planner Workbench Horizontal Plan.
MSC_PLAN_CONSTRAINTS MSC_PLAN_ORG_KPIS
Maintains the key performance indicators and thresholds for plans created on Oracle Supply Chain Hub.
MSC_PLAN_ORG_STATUS
Maintains the history of statuses of collaborating organizations in a plan.
MSC_PLAN_ORG_STATUSES MSC_PLAN_ORGANIZATIONS
This table stores the parameters relative to organizations that participate to the plan in Oracle Advanced Planning and Scheduling (APS). This table also contains the different companies which are collaborating in a supply or demand plan in
MSC_PLAN_PARTITIONS
The table stores partition information for plans.
MSC_PLAN_REFRESHES
This table used by collection program to keep track of the refresh numbers for each plan.
MSC_PLAN_SCHEDULES
This table stores master production schedules and master demand schedules for the planning process in an organization. This table is also used to store the input production schedule namefor In line vehicle sequencing (ILVS) on Oracle Supply
MSC _PL AN NER S
Th is ta bl e sto re s a nd ma in ta in s a l ist of pl an ne r co des .
MSC _PL AN S
Th is ta bl e sto re s d iffe ren t p la ns, w ith th ei r n ame s, a nd se tti ng s i n the Oracle Advanced Planning and Scheduling(APS) and Oracle Supply Chain Hub products.
MSC_PO_REQUISITIONS_INTERFACE
Requisition Import interface table
MSC_PO_RESCHEDULE_INTERFACE
Requisition reschedule interface table
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
16/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com M SC _P Q_ RE SU LTS
S to re s re su lts o f d iffe re nt ty pe s o f p er so na l q ue ri es .
MSC_PROCESS_EFFECTIVITY
This table stores links between the bill of material and routings and store effectivities for this process.
MSC_PROFILES MSC_PROJECT_TASKS
This table stores the tasks maufacturing parameters.
M SC _P ROJ EC TS
Th is ta bl e s to re s th e m an ufa ctu ri ng p ar am ete rs fo r a g iv en p ro je ct and organization.
MSC_PURCHASE_ORDER_INTERFACE
This table stores the Purchase Order information to be rescheduled in the Source instance.
MSC_QUERY
Table used to pass data across sessions.
MSC_QUESTIONS_B
This table stores the seeded and user defined questions for Ask Oracle. The associated MSC_QUESTIONS_TL table contains the translated questions by language.
MSC_QUESTIONS_TL
This table contains the translated questions for Ask Oracle
MSC_REGION_LOCATIONS
Stores mapping of locations to regions. This includes separate records for the most specific region mapped as well as records for its parents.
MSC_REGIONS
This table contains geographical regions data
MSC_REGIONS_TEMP
This table temporarily contains geographical regions data needed during an ATP request.
MSC_RELATED_EXCEPTIONS
This table is for storing related exceptions to a custom exceptions. This table is not used presently.
MSC_REPETITIVE_PERIODS
Repetitive planning period start dates
MSC_RESERVATIONS
Material reservations
MSC_RESOURCE_CHANGES
Resource capacity modifications
MSC_RESOURCE_GROUPS
This table stores different resource groups.
M SC _R ES OU RC E_ HIE RAR CH Y_ MV MSC_RESOURCE_INSTANCE_REQS MSC_RESOURCE_REQUIREMENTS
This table stores the resource requirments generated by existing supplies.
M SC _R ES OU RC E_ SH IFTS
R es ou rc e s hi ft i nfo rm ati on
MSC_RESOURCES_CUM_F MSC_RESOURCES_F MSC_ROUTING_OPERATIONS
This tables stores the operations composing each routing.
M SC _R OU TIN GS
Th is ta bl e s to re s th e d iffe re nt r ou ti ng s a va il ab le f or a b il l o f material.
MSC_RP_CATEGORY_MV MSC_RP_CTB_DONOR_COMPONENTS MSC_RP_CTB_ORDER_COMPONENTS MSC_RP_ITEM_UPDATES MSC_RP_KPI MSC_RP_RELEASED_ORDERS MSC_SAFETY_STOC KS
Safety stock levels
MSC_SALES_ORDERS
This table stores sales order demand and reservations from source application instances.
MSC_SCHEDULING_RULES
This table stores the scheduling rules used to schedule lines.
MSC_SEC URITY_RU LES
This table is not used.
MSC_SELECTION_CRITERIA
MSC Selection Criteria Stores the UI Search selection criteria
MSC_SEQUENCE_DEPENDENT_SETUPS
The table stores the sequence dependent setups and tears down. This is used by HLS to ensure a minimun delay between two operations using the same resource.
MSC_SERIAL_NUMBERS
This table stores unit level details for an onhand item.
MSC_SHIFT_DATES
Workday calendar shift dates
M SC _S HIFT_ EX CEP TION S
Wo rk da y c al en da r s hi ft e xc ep ti on s
MSC_SHIFT_TIMES
Workday calendar shift times
MSC _SH OR T_ TEXT
Th is ta bl e Sto re s th e Sh ort te xt C onte nt
MSC_SIMULATION_SETS
This table stores the different simulation sets.
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
17/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_SINGLE_LVL_PEG
Single level supply to supply or supply to demand pegging. Currently used for DRP plans
MSC_SNAPSHOT_TASKS
Tasks to be performed by Snapshot Workers
M SC _S OR T_ DA TA
Th is ta bl e d es cr ib es th e s orte d d eta il s u se d b y th e Fi nd w in do w.
MSC_SOURCING_HISTORY
Historical information related to sourcing.
MSC_SOURCING_RULES
This table stores sourcing rules and bills of distribution information.
M SC _S OU RC IN G_ TR AN SA CTION S MSC_SQLLOAD_PARAMETERS
This table stores sql load parameters like table name, bindsize, number of rows etc.
MSC_SR_ASSIGNMENTS
This table stores the assignment of sourcing rules (or bills of distribution) to item, organization, category, or at the global level.
MSC_SR_RECEIPT_ORG
Receiving Organizations for Sourcing Rules or Bills of distribution
MSC_SR_SOURCE_ORG
Source organization for Sourcing Rules or Bills of distribution
MSC_SR_ZN_AGGR_IBUC
Source side table that Stores the aggregated quantity of the install base item instances at item,date,zone level
MSC_SRP_ITEM_EXCEPTIONS MSC_ST_ASSIGNMENT_SETS
The staging table used by the collection program to valid and process data for table MSC_ASSIGNMENT_SETS.
MSC_ST_ATP_RULES
The staging table used by the collection program to validate and process data for table MSC_ATP_RULES.
MSC_ST_BILL_OF_RESOURCES
The staging table used by the collection program to validate and process data for table MSC_BILL_OF_RESOURCES.
MSC_ST_BIS_BUSINESS_PLANS
The staging table used by the collection program to validate and process data for table MSC_BIS_BUSINESS_PLANS.
MSC_ST_BIS_PERIODS
The staging table used by the collection program to validate and process data for table MSC_BIS_PERIODS.
MSC_ST_BIS_PFMC_MEASURES
The staging table used by the collection program to validate and process data for table MSC_BIS_PFMC_MEASURES.
MSC_ST_BIS_TARGET_LEVELS
The staging table used by the collection program to validate and process data for table MSC_BIS_TARGET_LEVELS
MSC_ST_BIS_TARGETS
The staging table used by the collection program to valid and process data for table MSC_BIS_TARGETS.
MSC_ST_BOM_COMPONENTS
The staging table used by the collection program to valid and process data for table MSC_BOM_COMPONENTS.
MSC _ST_BOMS
Th e sta gi ng ta bl e u se d b y th e co ll ecti on p ro gra m to va li d a nd process data for table MSC_BOMS.
MSC_ST_BOR_REQUIREMENTS
The staging table used by the collection program to valid and process data for table MSC_BOR_REQUIREMENTS.
MSC_ST_BUDGETS_F MSC_ST_CAL_WEEK_START_DATES
The staging table used by the collection program to validate and process data for table MSC_CAL_WEEK_START_DATES.
MSC_ST_CAL_YEAR_START_DATES
The staging table used by the collection program to validate and process data for table MSC_YEAR_START_DATES.
MSC_ST_CALENDAR_DATES
The staging table used by the collection program to validate and process data for table MSC_CALENDAR_DATES.
MSC_ST_CALENDAR_EXCEPTIONS
This is an interface table for staging exception dates for calendar from Legacy Instances. The 'Pre-Processor' would then validate the data in this table and insert into MSC_CALENDAR_EXCEPTIONS.
MSC_ST_CALENDAR_SHIFTS
The staging table used by the collection program to validate and process data for table MSC_CALENDAR_SHIFTS.
MSC_ST_CALENDARS
This is an interface table for staging definition of workday calendars from Legacy Instances. The 'Pre-Processor' would then validate the data in this table and insert into MSC_CALENDARS.You can follow any of the four following type of quar
MSC_ST_CATEGORY_SETS
The staging table used by the collection program to validate and process data for table MSC_CATEGORY_SETS.
MSC_ST_CO_PRODUCTS
This table is used for collecting the CO Product Bill in Legacy Collections
MSC_ST_COMPANY_USERS
Staging table for user company association information.
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
18/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_ST_COMPONENT_SUBSTITUTES
The staging table used by the collection program to validate and process data for table MSC_COMPONENT_SUBSTITUTES.
MSC_ST_COSTS_F MSC_ST_DEMAND_CLASSES
The staging table used by the collection program to validate and process data for demand classes.
M SC _S T_ DEM AN DS
Th e s ta gi ng ta bl e u se d b y th e c ol le cti on p ro gr am to v al id ate a nd process data for table MSC_DEMANDS.
MSC_ST_DEMANDS_CUM_F MSC_ST_DEMANDS_F MSC_ST_DEMANTRA_F MSC_ST_DEMANTRA_ODS_F MSC_ST_DEPARTMENT_RESOURCES
The staging table used by the collection program to validate and process data for table MSC_DEPARTMENT_RESOURCES.
MSC_ST_DESIGNATORS
The staging table used by the collection program to validate and process data for table MSC_DESIGNTORS.
MSC_ST_DOC_ATTACHMENTS
This staging table Stores the Attachment information
MSC_ST_EAM_ACT_ASSOCIATIONS MSC_ST_EAM_ASSET_EQUIP_DTLS MSC_ST_EXCEPTIONS_F MSC_ST_GROUP_COMPANIES
The staging table used by the collection program to validate and process data for table MSC_GROUP_COMPANIES
M SC _S T_ GR OU PS
Th e s ta gi ng ta bl e u se d b y th e c ol le cti on p ro gr am to v al id ate a nd process data for table MSC_GROUPS
MSC_ST_INTERORG_SHIP_METHODS
The staging table used by the collection program to validate and process data for table MSC_INTERORG_SHIP_METHODS.
MSC_ST_ITEM_CATEGORIES
The staging table used by the collection program to validate and process data for table MSC_ITEM_CATEGORIES.
MSC_ST_ITEM_CUSTOMERS
Staging table to hold item customers data.
MSC_ST_ITEM_INVENTOR Y_F MSC_ST_ITEM_ORDERS_F MSC_ST_ITEM_SOURCING
This is a denormalized table for staging Sourcing Rules related data from Legacy Instances. The data in this table would be processed by the 'Pre-Processor' and sent to MSC_ST_ASSIGNMENT_SETS, MSC_ST_SR_ASSIGNMENTS, MSC_ST_SOURCING_RULES, M
MSC_ST_ITEM_SUBSTITUTES
The staging table used by the collection program to validate and process data for table MSC_DEMANDS.
MSC_ST_ITEM_SUPPLIERS
The staging table used by the collection program to validate and process data for table MSC_ITEM_SUPPLIERS.
MSC_ST_ITEM_WIPS_F MSC_ST_ITEMS_F MSC _ST_J OB_ OP_ RESOU RC ES MSC_ST_JOB_OPERATIONS MSC_ST_JOB_REQUIREMENT_OPS MSC_ST_LOCATION_ASSOCIATIONS
The staging table used by the collection program to validate and process data for table MSC_LOCATION_ASSOCIATIONS.
MSC _ST_L ON G_ TEXT
Th is ta bl e Sto re s th e L on g te xt C on te nt
MSC _ST_N ET_ RES_ IN ST_ AVAIL MSC_ST_NET_RESOURCE_AVAIL
The staging table used by the collection program to validate and process data for table MSC_NET_RESOURCE_AVAIL.
MSC_ST_OPERATION_COMPONENTS
The staging table used by the collection program to validate and process data for table MSC_OPERATION_COMPONENTS.
MSC_ST_OPERATION_NETWORKS
The staging table used by collections program to validate and process data for table MSC_OPERATION_NETWORKS.
MSC_ST_OPERATION_RESOURCE_SEQS
The staging table used by the collection program to validate and process data for table MSC_OPERATION_RESOURCE_SEQS.
MSC_ST_OPERATION_RESOURCES
The staging table used by the collection program to validate and process data for table MSC_OPERATION_RESOURCES.
MSC_ST_PARAMETERS
The staging table used by the collection program to validate and process data for table MSC_PARAMETERS.
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
19/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_ST_PARTNER_CONTACTS
The staging table used by the collection program to validate and process data for table MSC_PARTNER_CONTACS.
MSC_ST_PERIOD_START_DATES
The staging table used by the collection program to validate and process data for table MSC_PERIOD_START_DATES.
MSC_ST_PLANNERS
The staging table used by the collection program to validate and processdata for table MSC_PLANNERS....
MSC_ST_PROCESS_EFFECTIVITY
The staging table used by the collection program to validate and process data for table MSC_PROCESS_EFFECTIVITY.
M SC _S T_ PR OFIL ES
Th is i s th e s ta gi ng ta bl e to k ee p th e p ro fi le o pti on s
MSC_ST_PROJECT_TASKS
The staging table used by the collection program to validate and process data for table MSC_PROJECT_TASKS.
MSC_ST_PROJECTS
The staging table used by the collection program to validate and process data for table MSC_PROJECTS.
MSC_ST_REGION_LOCATIONS
The staging table used by the collection program to validate and process data for table MSC_REGION_LOCATIONS.
M SC _S T_ REGI ON S
Th e s ta gi ng ta bl e u se d b y th e c ol le cti on p ro gr am to v al id ate a nd process data for table MSC_REGIONS.
MSC_ST_RESERVATIONS
The staging table used by the collection program to validate and process data for table MSC_RESERVATIONS.
MSC_ST_RESOURCE_CHANGES
The staging table used by the collection program to validate and process data for table MSC_RESOURCE_CHANGES.
MSC_ST_RESOURCE_GROUPS
The staging table used by the collection program to validate and processdata for table MSC_ST_RESOURCE_CHANGES.
MSC_ST_RESOURCE_INSTANCE_REQS MSC_ST_RESOURCE_REQUIREMENTS
The staging table used by the collection program to validate and process data for table MSC_RESOURCE_REQUIREMENTS.
MSC_ST_RESOURCE_SHIFTS
The staging table used by the collection program to validate and process data for table MSC_RESOURCE_SHIFTS.
MSC_ST_R ESOURC ES_CUM_F MSC_ST_RESOURCES_F MSC_ST_ROUTING_OPERATIONS
The staging table used by the collection program to validate and process data for table MSC_ROUTING_OPERATIONS.
MSC_ST_ROUTINGS
The staging table used by the collection program to validate and process data for table MSC_ROUTINGS.
MSC_ST_SAFETY_STOCKS
The staging table used by the collection program to validate and process data for table MSC_SAFETY_STOCKS.
MSC_ST_SALES_ORDERS
The staging table used by the collection program to validate and process data for table MSC_SALES_ORDERS.
MSC_ST_SERIAL_NUMBERS
The staging table used by the collection program to validate and process data for table MSC_SERIAL_NUMBERS.
MSC_ST_SHIFT_DATES
The staging table used by the collection program to validate and process data for table MSC_SHIFT_DATES.
MSC_ST_SHIFT_EXCEPTIONS
The staging table used by the collection program to validate and process data for table MSC_SHIFT_EXCEPTIONS.
MSC_ST_SHIFT_TIMES
The staging table used by the collection program to validate and process data for table MSC_SHIFT_TIMES.
MSC_ST_SHORT_TEXT
This staging table Stores the Short text Content
MSC_ST_SIMULATION_SETS
The staging table used by the collection program to validate and process data for table MSC_SIMULATION_SETS.
MSC_ST_SOURCING_HISTORY
Historical information related to Sourcing
MSC_ST_SOURCING_RULES
The staging table used by the collection program to validate and process data for table MSC_SOURCING_RULES.
MSC_ST_SR_ASSIGNMENTS
The staging table used by the collection program to valid and process data for table MSC_SR_ASSIGNMENTS.
MSC_ST_SR_RECEIPT_ORG
The staging table used by the collection program to validate and process data for table MSC_SR_RECEIPT_ORG.
MSC_ST_SR_SOURCE_ORG
The staging table used by the collection program to validate and process data for table MSC_SR_SOURCE_ORG.
MSC_ST_SUB_INVENTORIES
The staging table used by the collection program to validate and process data for table MSC_SUB_INVENTORIES.
MSC_ST_SUPPLIER_CAPACITIES
The staging table used by the collection program to validate and process data for table MSC_SUPPLIER_CAPACITIES.
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
20/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_ST_SUPPLIER_FLEX_FENCES
The staging table used by the collection program to validate and process data for table MSC_SUPPLIER_FLEX_FENCES.
MSC_ST_SUPPLIERS_F M SC _S T_ SU PPL IE S
Th e s ta gi ng ta bl e u se d b y th e c ol le cti on p ro gr am to v al id ate a nd process data for table MSC_SUPPLIES.
MSC_ST_SUPPLIES_F MSC_ST_SYSTEM_ITEMS
The staging table used by the collection program to valid and process data for table MSC_SYSTEM_ITEMS.
MSC_ST_TRADING_PARTNER_SITES
The staging table used by the collection program to validate and process data for table MSC_TRADING_PARTNER_SITES.
MSC_ST_TRADING_PARTNERS
The staging table used by the collection program to validate and process data for table MSC_TRADING_PARTNERS.
MSC_ST_UNIT_NUMBERS
The staging table used by the collection program to validate and process data for table MSC_UNIT_NUMBERS.
MSC_ST_UNITS_OF_MEASURE
The staging table used by the collection program to validate and process data for table MSC_UNITS_OF_MEASURE.
MSC_ST_UOM_CLASS_CONVERSIONS
The staging table used by the collection program to validate and process data for table MSC_UOM_CLASS_CONVERSIONS.
MSC_ST_UOM_CONVERSIONS
The staging table used by the collection program to validate and process data for table MSC_UOM_CONVERSIONS.
MSC_ST_VISITS MSC_ST_WAREHOUSE_F MSC_ST_WO_ATTRIBUTES MSC_ST_WO_MILESTONES MSC_ST_WO_OPER ATION _R EL MSC_ST_WO_SUB_COMP MSC _ST_WO_ TASK_H IER AR CH Y MSC_ST_WORK_BREAKDOWN_STRUCT MSC_ST_WORKDAY_PATTERNS
This is an interface table for staging days on/days off patterns for your calendar and your shifts from Legacy Instances. The 'PreProcessor' would then validate the data in this table and insert into MSC_WORKDAY_PATTERNS.SEQ_NUM is the ord
MSC_ST_ZN_AGGR_IBUC
This is the staging table that Stores the aggregated quantity of the install base item instances at item,date,zone level
MSC_ST_ZONE_REGIONS
The staging table used by the collection program to validate and process data for table MSC_ZONE_REGIONS.
MSC_SUB_INVENTORIES
MSC_SUB_INVENTORIES stores information about the netting type of eachsubi nventory defined in Oracle Inventory. Each subinventory will havean entry in MSC_SUB_INVENTORIES and NETTING_TYPE will indicate whetheror not that subinventory should
MSC_SUP_DEM_ENTRIES
This table holds transaction data for Oracle Collaborative planning.
MSC_SUP_DEM_HISTORY
Table to maintain historical information on data loaded into Oracle Collaborative planning.
M SC _S UP _H EA DER S_ IN TE RFAC E MSC_SUP_LIN ES_IN TERFACE M SC _S UP DEM _H DR S_ IN TE RFAC E MSC_SUPDEM_LINES_INTERFACE
Supply demand lines interface table
MSC_SUPPLIER_CAPACITIES
This table stores the capacity information for planned items within an MPS, MRP, or DRP plan. Each row stores the capacity within a date range for a specific supplier of an item.
MSC_SUPPLIER_FLEX_FENCES
MSC_SUPPLIER_FLEX_FENCES stores the supplier flex fence information for planned items within an MPS, MRP, or DRP plan. Each row stores the tolerance percentage a supplier allows for a certain number of days in advance for an item.This tab
MSC_SUPPLIER_LT_OUTCOMES
This table stores the supplier lead time variabilities
MSC_SUPPLIER_PLANS
MSC_SUPPLIER_PLANS is a generic table used by forms for querying data. This table is used to display supplier plan information in the Planner Workbench. QUERY_ID is the query identifier used while popula ting the table. The QUANTITY column
M SC _S UP PL IE R_ REQU IR EME NTS MSC_SUPPLIERS_F
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
21/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com M SC _S UP PL IE S
Th is ta bl e l is ts a ll th e s up pl ie s f or th is p la n. Th e s up pl ie s c re ate d b y the planning process are added to this table.
MSC_SUPPLIES_F MSC_SYSTEM_ITEMS
MSC_SYSTEM_ITEMS stores the organization items defined at source applications. It also stores a copy of items planned by the planning process. Most of the columns in MSC_SYSTEM_ITEMS correspond to columns from the Oracle Inventory Item mast
MSC_TEMP_ALLOC_DEMANDS
Child table to MSC_DEMANDS storing pre-allocated demands
MSC_TEMP_ALLOC_SUPPLIES
Child table to MSC_SUPPLIES storing pre-allocated supplies. Used during ATP post plan processing
M SC _TE MP_ RE GION _L OC ATION S MSC_TEMP_SALES_ORDERS MSC_TEMP_SUMM_RES
Temp table for calculating resource summary data. (unused)
MSC_TEMP_SUMM_SD
Temp table for calculating supply/demand summary data during post plan processing
MSC_TEMP_SUMM_SO
Temp table used to calculate summary data for sales orders during post plan processing
MSC_TEMP_SUMM_SUP
Temp table for calculating supply summary data for post plan processing. (unused)
MSC _TP_ID _LID
Th is ta bl e i s u se d b y th e co ll ecti on p rog ra m to ma in tai n the correspondence between the source instances identifiers and the planning identifiers for trading partners.
MSC_TP_SITE_ID_LID
This table is used by the collection program to maintain the correspondence between the source instances identifiers and the planning identifiers for trading partner sites.
MSC_TRADING_PARTNER_MAPS
This table contains mapping of data between MSC_TRADING_PARTNERS andMSC_COMPANIES and MSC_COMPANY_SITES table.
MSC_TRADING_PARTNER_SITES
This table stores information about the different sites of an organization.
MSC_TRADING_PARTNERS
This table stores information about the different organizations: customers, vendors, and planned organizations.
MSC_UNDO_DETAILS
This table describes the details of changes made to plan output.
MSC_UNDO_SUMMARY
This table describes the summary of changes made to plan output.
M SC _U NIT_ NU MBE RS
Th is ta bl e s to re s th e d iffe re nt u ni ts n um be rs .
M SC _U NITS_ OF_ MEA SU RE
U ni t o f m ea su re d efi ni ti on s
MSC_UOM_CLASS_CONVERSIONS
Conversions between base units of two different classes
MSC_UOM_CONVERSIONS
This table stores the different non-base unit of measures known conversions.
MSC_USER_ADV_EXPRESSIONS
User Defied expressions for custom exceptions.
MSC_USER_EXCEPTION_COMPONENTS
Holds components of a custom exception: Select clause attributes, simple condition attributes, advanced condition attributes
MSC_USER_EXCEPTION_NTFS
Recipients for exception notifications
MSC_USER_EXCEPTIONS
MSC_USER_EXCEPTIONS is the header table for user defined exceptions. It stores attributes such as the name and the schedule for the user defined exception.
MSC_VISITS MSC_WAREHOUSE_F MSC_WIP_JOB_DTLS_INTERFACE
MSC_WIP_JOB_SCHEDULE_INTERFACE
Requests to add/delete/ modify material/resource requirements for jobs and schedule s Requests to create or modify jobs and schedules
MSC_WO_ATTRIBUTES MSC_WO_MILESTONES MSC_WO_OPERATION_REL MSC_WO_SUB_COMP MSC_WO_TASK_HIERARCHY MSC_WORK_BREAKDOWN_STRUCT MSC_WORKBENCH_DISPLAY_OPTIONS
User display preferences for Planner Workbench in APS and horizontal plan screen in Supply Chain Hub.
MSC_WORKDAY_PATTERNS
MSC_WORKDAY_PATTERNS stores the days on/days off patterns
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
22/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com for your calendar and your shifts. You can define multiple days on/days off to form a repetitive pattern. The calendar compile program (MSCPCL) will create a workday calendar based o MSC_X_EXCEPTION_DETAILS
This table contains exceptions generated in Oracle Collaborative planning
MSC_X_ITEM_ORGS_GTT MSC_X_ITEM_SITES_GTT MSC _X_ ITEM_ SU PPLIER S_ GTT MSC_X_SECURITY_RULES
This table contains the security rules for processing data in Oracle Collaborative planning.
MSC_ZONE_REGIONS
This table contains the mapping between user-defined zone and included regions
ASCP Views:
VIEW NAME
DESCRIPTION
M SC _A CTION S_ TR EE _V
Th is v ie w s ho ws a ll th e e xc ep ti on s i n th e tr ee
MSC_ACTION_ORDERS_TREE_V
Ths view shows the recommendations in the tree
MSC_ACTION_SUMMARY_V
This view show the exception group counts in the tree
MSC_ALLOCATION_ASSIGNMENTS_V
This view shows the allocation assignments
MSC _AL TER NATE_ RESOU RC ES_ V MSC_ANSWERS_V MSC_APPS_INSTANCES_V MSC_AVAILABLE_ORGS_V M SC _A VA IL _R ES OU RC E_ DE TAIL _V MSC_AVAIL_RESOURCE_SUMMARY_V MSC_BILL_OF_RESOURCES_V MSC_BOD_SOURCING_RULES_V MSC_BOD_TASK_SR_LEVELS_V MSC_CATEGORIES_TREE_V
This view shows all the categories in the tree
MSC_COMPONENTS_SC_V
This view shows all the components in the tree
MSC_COMPONENTS_TREE_V M SC _C ON STR AIN ED _FOR EC AS T_ V MSC _C O_ PR OD UC TS_V
Th us vi ew sh ow s a ll the co -p ro du cts
MSC_CRITICAL_PATHS_V MSC_CUST_BUCKET_V MSC_CUST_SUP_ORG_V MSC_DEMANDS_MV_V M SC _D EM AN D_ CL AS SE S_ V
Th is v ie w p ic ks u p a ll th e d em an d c la ss es
MSC_DEMAN D_PEGGIN G_V
Demand pegging
MSC_EXCEPTION_DETAILS_V
this view picks up all the valid exception details
MSC_EXCEPTION_LOOKUP_V MSC_EXCEPTION_SUMMARY_V M SC _E XC EP TI ON _TH RE SH OL DS_ V MSC_EXC_DETAIL_ALL_V MSC_EXC_DETAIL_ITEM_V MSC _EXC _D ETAIL_ RESOU RC E_ V M SC _FL P_ DEM AN D_ SU PP LY _ATP _V
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
23/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_FLP_DEMAND_SUPPLY_V MSC_FLP_D EMAN D_SU PPLY_V2 MSC_FLP_END_DEMAND2_V MSC_FLP_END_DEMAND_V MSC_FLP_ONHAND_V MSC_FLP_OP_ATP_V MSC_FLP_OP_V MSC_FLP_RES_ATP_V MSC_FLP_RES_V MSC _FL P_ SU PPL Y_ ATP_ V
Vi ew o f su ppl y i nfo rma ti on
M SC _FL P_ SU PPL Y_ DEM AN D_ ATP _V MSC_FLP_SUPPLY_DEMAND_V MSC_FLP_SUPPLY_D EMAND_V2 MSC_FLP_SUPPLY_V
View of supply information
MSC_FORECAST_UPDATES_V
this view picks up all the forecast updates
MSC_INSTANCE_ORGS_V MSC_ITEMS_TREE_V MSC_ITEM_CROSS_REFS_V M SC _ITE M_ EX CEP TION _V
Th is v ie w p ic ks u p a ll th e i te m e xc ep ti on s
MSC_ITEM_EXCEPTION_V1
This view picks all the item exceptions at the plan level
MSC_ITEM_EXCEPTION_V2
this view picks the item exceptions at the plan level
MSC_ITEM_LOWEST_SR_LEVEL_V
Lowest sourcing level of an inventory org item
MSC_ITEM_SOURCING_LEVELS_V
this view picks up all the sources at various levels for an item
MSC_ITEM_SOURCING_V MSC _ITEM_SR _L EVEL S_ V
In ve nto ry i te ms so urc es vi ew
MSC_ITEM_SUPPLIER_V MSC_ITEM_TASK_SR_LEVELS_V MSC_ITEM_UOMS_VIEW MSC_LATE_ORDERS_MV_V MSC_LINE_ITEMS_LOV_V MSC_LOCATIONS_V MSC _MON TH LY_ SU PD EM_ SU M_ V MSC_MONTHLY_SUPPLY_DEMAND_V M SC _N ETTED _S UP PL Y_ DEM AN D_ V MSC_NET_AGGREGATE_V MSC_NET_CONSTRAINTS_V MSC_NET_DEMAND_SCHD_V MSC_NET_EXCP_CRITERIA_V MSC_NET_EXC_DETAIL_V MSC_NET_EXC_GROUP_V MSC_NET_EXC_TYPE_V MSC_NET_FILTER_CRITERIA_V MSC_NET_GOAL_V MSC_NET_HZ_GRAPH_V MSC_NET_OPTIMIZE_V MSC_NET_OPTION_V MSC_NET_ORG_V M SC _N ET_ PL AN S_ V
to d is pl ay th e p la n L OV i n th e fr om p la n o f P la n C om pa ri so n R ep or ts
M SC _N ET_ PL AN S_ V2
To d is pl ay th e p la n L OV i n th e to p la n o f P la n C om pa ri so n R ep or ts
MSC_NET_SUPPLY_SCHD_V MSC_NET_VERTICAL_GRAPH_V MSC_OPERATION_NETWORKS_V
this view shows all the operations in the network routing
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
24/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC _OR DER S_ V
Th is vi ew s hj ow s a ll th e su pp li es,d ema nd s a nf sa le s o rd ers
MSC_ORGS_TREE_V MSC_ORG_SEC_RESP_V MSC_PARAMETERS_V MSC_PDR_ITEM_DETAILS_V MSC_PDR_LATE_ORDER_EXC_V MSC_PDR_MAT_RES_EXC_V MSC_PDR_PLAN_DETAILS_V MSC_PDR_PLAN_DETAILS_V1 M SC _P DR _R ESOU RC E_ DETA IL S_ V MSC_PDR_VERT_LIST_V MSC_PLANNED_RESOURCES_V
This view shows all the resources used in a plan
MSC_PLANS_TREE_V MSC_PLAN_ORGANIZATIONS_V
MPS/MRP/DRP plan organizations view
MSC_PLAN_ORGS_V MSC_PLAN_PARAMETERS_V MSC_PLAN_SCHEDULES_V
Supply/Demand Schedule information for planner.
MSC_PLAN_SCHED_V MSC_PO_REQUISITIONS_V
This view contains all the information necessary to create approved or unapproved requisitions in Oracle Purchasing. This view is used in XML-outbound
MSC_PO_RESCHEDULE_DETAILS_V
This view contains the line information of a rescheduled purchase order. This view is used in XML-outbound.
MSC_PO_RESCHEDULE_HEADER_V
This view contains the header information of a rescheduled purchase order. This view is used in XML-outbound
MSC_PROCESS_EFFECTIVITY_V M SC _P ROD UC T_ FA MIL IES _TR EE _V MSC_PROJECTS_TREE_V
This view shows all the projects in a plan in the tree
MSC_PROJECT_ITEMS_TREE_V
this view shows all the project items in the tree
MSC_PUBLISH_ITEMS_LOV_V MSC_QUESTIONS_VL MSC_RELATED_EXC_DETAILS_V MSC_RESOURCES_TREE_V
This view shows all the resources in the tree
MSC _R ESOU RC E_ ITEMS_ TR EE_V MSC_RESOURCE_REQUIREMENTS_V
this view shows all the resource requirements
MSC_ROUTING_OPERATIONS_V
This view shows all the operations in a routing
MSC_SAFETY_STOCKS_V MSC _SC ATP_ ITEM_ SR _LEVEL S_ V MSC_SCATP_SOURCES_V MSC_SCH_RULE_CRITERIA_V MSC_SCH_RULE_NAMES_V MSC_SC_BILL_BOM_V MSC_SC_BILL_MAKE_AT_V MSC_SC_BILL_SF_V
Supply chain bill source from view
MSC_SC_BILL_V MSC_SC_BILL_WU_V
Supply chain bill w here used view
MSC_SEARCH_ACTIONS_V
this view shows all the search criteria for exceptions
M SC _S EA RC H_ ITE MS_ V
th is s ho ws a ll th e s ea rc h c ri te ri a fo r i te ms
MSC_SEARCH_ORGS_V
this view shows all the search criteria for organizations
MSC_SEARCH_PROJECTS_V
this view shows all the search criteria for projects
MSC_SEARCH_RESOURCES_V
this view shows all the search criteria for resources
MSC_SEARCH_SUPPLIERS_V
this view shows the search criteria for suppliers
MSC_SECURITY_RULES_V MSC_SELECTED_ORGS_V
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
25/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com MSC_SOURCES_V
Inventory item source view
MSC_SR_ASSIGNMENTS_V MSC_SR_RECEIPT_ORG_V M SC _S R_ SOU RC E_ OR G_ V
S ou rc in g r ul e s ou rc e o rg an iz at io n v ie w
MSC_SR_VIEW_CON_V MSC_SR_VIEW_EXP_V MSC_SR_VIEW_MAKE_AT_V MSC_SR_VIEW_REC_V MSC_SR_VIEW_V MSC_SUBSTITUTE_COMPONENTS_V
Substitute component view
MSC_SUB_INVENTORIES_V MSC_SUPPLIERS_LOV_V MSC_SUPPLIERS_TREE_V MSC_SUPPLIER_CAPACITY_V
This view shows the capacities for all the suppliers
MSC _SU PPL IER _FL EX_ FEN CES_ V M SC _S UP PL IE R_ LT_ OU TC OM ES _V MSC_SUPPLIES_OUTBOUND_V
This view lists all the supplies for the plan. This view is used in XMLoutbound
MSC_SUPPLY_PEGGING_V
Supply pegging
MSC_SUP_DEM_ENTRIES_UI_V MSC_SUP_DEM_ENTRIES_V MSC_SUP_D EM_EN TR IES_VMI_V MSC_SUP_DEM_ENT_CUSTOM_EX_V MSC_SUP_DEM_HISTORY_V MSC_SUP_DEM_HZ_UI_V MSC_SUP_DEM_SECURITY_V M SC _S UP _D EM _TR AN SA CTION S_ V MSC_SUP_DEM_UPDATE_SECURITY_V M SC _S YS TEM _ITEM S_ SC _V
Th is v ie w s ho ws a ll th e i te ms
MSC_TREE_SELECTION_V M SC _U ND O_ DE TAIL S_ V
th is v ie w s ho ws a ll th e c ha ng es m ad e to th e p la n o utp ut
MSC_UNDO_SUMMARY_V
this view shows the summary of all the changes made to the plan output
MSC_UOM_C ONVERSIONS_VIEW MSC _VER TIC AL _PL AN _V
th is vi ew sh ow s th e ve rti ca l p la n
MSC_VMI_ITEM_V MSC_WIP_JOB_COMPONENTS_V
This view contains requests to add/delete/modify material for existing discrete jobs or repetitive schedules. This view is used in XML outbound
MSC_WIP_JOB_OPERATIONS_V
This view contains the information about operations for existing discrete job or repe titive sche dules. This vie w is used i n XML outbound
MSC_WIP_JOB_RESOURCES_V
This view contains requests to add/delete/modify resource requirements for existing discrete jobs or repetitive schedules. This view is used in XML outbound.
MSC_WIP_JOB_SCHEDULE_V
This view contains request to create or modify discrete jobs or repetitive schedules. This view is used in XML-outbound
MSC_X_COMPANY_ORG_LOV_V MSC _X_ COMPAN Y_ SITES_ LOV_V MSC_X_CUSTOMER_LOV_V MSC_X_ITEMS_LOV_V MSC_X_ITEM_EXCEPTIONS_V MSC_X_ORGS_LOV_V MSC_X_SUPPLIER_LOV_V MSC_X_SUPPLY_DEMAND_V
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
26/27
1/6/2016
Oracle Advanced Supply Chain Planning ( ASCP) Tables, Views | www.OracleAppsQuery.com OL D_ ITEM_ SOU RC IN G_ LEVEL S_V OLD_SC_BILL_SF_V OLD_SC_BILL_WU_V
‹ Oracle Advanced Product Catalog Tables , Views
up
Oracle Alerts Tables, Views ›
Printer-friendly version
Hits Counter
Disclaimer This site is not affiliated to www.oracle.com . Few articles on this site are not completely prepared by me, content is edited and complied after referring various web sites to make visitor's job easy. All trademarks, trade names, service marks, copyrighted work, logos referenced herein belong to their respective owners/companies. The statements and opinions expressed here do not necessarily represent any organization.If any of the posting is violating copyright and you want us to remove that content. Please contact
[email protected]
Copyright © 2016,
http://w ww .or acl eappsquer y.com /?q= or acl e- apps- advanced- suppl y- chai n- pl anni ng- tabl es- vi ew s- ascp
Theme by zymphonies
27/27