APPS.OPI_EDW_JOB_RSRC_FOPM_SZ dependencies on SY_ORGN_MST

Line 40: SY_ORGN_MST OM,

36: PM_BTCH_HDR PBH
37: WHERE POD.BATCH_ID=PBH.BATCH_ID
38: ) BR,
39: CR_RSRC_DTL CR,
40: SY_ORGN_MST OM,
41: GL_PLCY_MST PM,
42: FM_OPRN_MST OPRM,
43: FM_OPRN_DTL OPRD,
44: MTL_SYSTEM_ITEMS ITEM_FK_V,

Line 173: FROM SY_ORGN_MST;

169: SELECT avg(nvl(vsize(UOM_CODE), 0))
170: FROM OPI_PMI_UOMS_MST;
171: CURSOR LOC_PK is
172: SELECT avg(nvl(vsize(ORGN_CODE), 0))
173: FROM SY_ORGN_MST;
174:
175: CURSOR TRX_DATE_PK is
176: SELECT avg(nvl(vsize(substr(edw_time_pkg.cal_day_fk
177: (POD.ACTUAL_CMPLT_DATE,SOB.SET_OF_BOOKS_ID),1,120)),0))

Line 181: SY_ORGN_MST OM,

177: (POD.ACTUAL_CMPLT_DATE,SOB.SET_OF_BOOKS_ID),1,120)),0))
178: FROM
179: PM_OPRN_DTL POD,
180: PM_BTCH_HDR BH,
181: SY_ORGN_MST OM,
182: GL_PLCY_MST PM,
183: GL_SETS_OF_BOOKS SOB
184: WHERE
185: BH.BATCH_ID=POD.BATCH_ID