APPS.OPI_EDW_COGS_FOPM_SZ dependencies on GL_PLCY_MST

Line 17: GL_PLCY_MST PM

13: FROM
14: OP_ORDR_HDR SH,
15: OP_ORDR_DTL SD,
16: SY_ORGN_MST OM,
17: GL_PLCY_MST PM
18: WHERE SH.order_id = sd.order_id
19: AND SH.orgn_code = OM.orgn_code
20: AND OM.co_CODE = PM.co_code
21: AND SD.LINE_STATUS >= 20

Line 75: FROM gl_plcy_mst;

71: CURSOR c_other_dtl IS
72: SELECT AVG(Nvl(Vsize(EDW_TIME_PKG.CAL_DAY_FK(Sysdate, SOB_ID) ),0)) date_fk,
73: AVG(NVL(VSIZE(SOB_ID),0)) SOB_ID,
74: AVG(NVL(VSIZE(ORG_ID),0)) ORG_ID
75: FROM gl_plcy_mst;
76:
77: x_instance_fk NUMBER;
78:
79: trans_dtl_rec c_trans_dtl%ROWTYPE;