APPS.OPI_EDW_JOB_DETAIL_FOPM_SZ dependencies on SY_ORGN_MST

Line 41: SY_ORGN_MST OM,

37: AND BH.ROUTING_ID=RT.ROUTING_ID(+)
38: AND BH.BATCH_STATUS in (-1,0,1,2,3,4)
39: AND BD.LINE_TYPE=1
40: ) B,
41: SY_ORGN_MST OM,
42: IC_ITEM_MST IM,
43: IC_PLNT_INV PI,
44: GL_SETS_OF_BOOKS SOB,
45: GL_PLCY_MST PM,

Line 154: FROM SY_ORGN_MST;

150: SELECT avg(nvl(vsize(UOM_CODE), 0))
151: FROM OPI_PMI_UOMS_MST;
152: CURSOR LOC_PK is
153: SELECT avg(nvl(vsize(ORGN_CODE), 0))
154: FROM SY_ORGN_MST;
155:
156: CURSOR TRX_DATE_PK is
157: SELECT avg(nvl(vsize(substr(edw_time_pkg.cal_day_fk
158: (BH.ACTUAL_CMPLT_DATE,SOB.SET_OF_BOOKS_ID),1,120)),0))

Line 161: SY_ORGN_MST OM,

157: SELECT avg(nvl(vsize(substr(edw_time_pkg.cal_day_fk
158: (BH.ACTUAL_CMPLT_DATE,SOB.SET_OF_BOOKS_ID),1,120)),0))
159: FROM
160: PM_BTCH_HDR BH,
161: SY_ORGN_MST OM,
162: GL_PLCY_MST PM,
163: GL_SETS_OF_BOOKS SOB
164: WHERE
165: BH.PLANT_CODE = OM.ORGN_CODE