APPS.OPI_EDW_JOB_DETAIL_FOPM_SZ dependencies on GL_PLCY_MST

Line 45: GL_PLCY_MST PM,

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,
46: MTL_SYSTEM_ITEMS ITEM_FK_V,
47: IC_WHSE_MST IW,
48: EDW_LOCAL_INSTANCE inst,
49: OPI_PMI_UOMS_MST UOM,

Line 146: FROM gl_plcy_mst;

142:
143:
144: CURSOR CURR_PK is
145: SELECT avg(nvl(vsize(BASE_CURRENCY_CODE), 0))
146: FROM gl_plcy_mst;
147:
148:
149: CURSOR UOM_PK is
150: SELECT avg(nvl(vsize(UOM_CODE), 0))

Line 162: GL_PLCY_MST PM,

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
166: AND OM.CO_CODE = PM.co_code