Oracle EBs Apps Blog of Mahfuz, OPM and OBIEE Consultant

Saturday 5 December 2015

OPM FORMULA TO EXECUTION WORK FLOW TABLES


OPM Tables and Execution steps Workflow

01. FORMULA CLASS
a) GMD_FORMULA_CLASS_B
b) GMD_FORMULA_CLASS_TL

02. FORMULA
a) FM_FORM_MST_B // LINK : 01.A=02.A.CLASS_ID
b) FM_FORM_MST_TL
c) FM_MATL_DTL // LINK : 02.A.FORMULA_ID=02.C.FORMULA_ID

03. ACTIVITYS
a) GMD_ACTIVITIES_B
B) GMD_ACTIVITIES_TL

04.OPERATIONS
a) GMD_OPERATIONS_B
b) GMD_OPERATIONS_TL
c) GMD_OPERATION_ACTIVITIES //LINK: 03.A=04.C
d) GMD_OPERATION_RESOURCES // LINK: 05.A.04.D


05. RESOURCES
a) CR_RSRC_MST_B
b) CR_RSRC_MST_TL
c) GMP_RESOURCE_PARAMETERS
d) GMP_PROCESS_PARAMETER_B // LINK : 05.A=05.D
d) GMP_PROCESS_PARAMETER_TL

06.ROUTINGS
a) GMD_ROUTINGS_CLASS_B
b) GMD_ROUTINGS_CLASS_TL
c) GMD_ROUTINGS_B
d) GMD_ROUTINGS_TL
e) FM_ROUT_DTL // LINK : 04.A=06.E.OPERATION_ID
f) FM_ROUT_DEP // LINK : 06.E.06.F

07. RECIPES
a) GMD_RECIPES_B
b) GMD_RECIPES_TL
c) GMD_RECIPE_ROUTING_STEPS // 07.A=07.C AND 06.C=07.C
d) GMD_RECIPE_VALIDITY_RULES // ORG_ASSIGN





****************************************************************************************************
08. BATCH CREATION
a) GME_BATCH_HEADER
b) GME_BATCH_STEP_ACTIVITYS
c) GME_BATCH_STEP_RESOURCES
d) GME_MATERIAL_DETAILS
f) GME_RESOURCE_TXNS

09. BATCH RESERVATION
a) INV.MTL_RESERVATIONS // LINK : 08.D=09.A.DEMAND_SOURCE_LINE_ID

10. BATCH RELEASE
a) GMF.GMF_BATCH_REQUIRMENTS
b) INV.MTL_MATERIAL_TRANSACTIONS
c) INV.MTL_RESERVATIONS RECORD WILL BE DELETED OR NULL


11. BATCH STEP RELEASE


12. BATCH COMPLETED










No comments:

Post a Comment

Internal location is Already assigned to another Ship-to Address

      SELECT *   FROM hz_cust_accounts  WHERE ACCOUNT_NUMBER = 'R08'; -- CUST_ACCOUNT_ID =51401 , PARTY_ID= 235048    SELECT *   FRO...