APPS.OPI_EDW_JOB_RSRC_FOPM_SZ dependencies on GL_PLCY_MST

Line 41: GL_PLCY_MST PM,

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,
45: IC_WHSE_MST IW,

Line 158: FROM gl_plcy_mst;

154:
155:
156: CURSOR CURR_PK is
157: SELECT avg(nvl(vsize(BASE_CURRENCY_CODE), 0))
158: FROM gl_plcy_mst;
159:
160: CURSOR ACT_PK is
161: SELECT avg(nvl(vsize(ACTIVITY), 0))
162: FROM FM_ACTV_MST;

Line 182: GL_PLCY_MST PM,

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
186: AND BH.PLANT_CODE = OM.ORGN_CODE