APPS.OPI_EDW_RES_UTIL_FOPM_SZ dependencies on SY_ORGN_MST

Line 44: FROM SY_ORGN_MST ORG,

40: (SELECT ORG.ORGN_CODE,
41: RSRC.RESOURCES,
42: RSRC.STD_USAGE_UM,
43: GREATEST(ORG.LAST_UPDATE_DATE,RSRC.LAST_UPDATE_DATE) LAST_UPDATE_DATE
44: FROM SY_ORGN_MST ORG,
45: CR_RSRC_MST RSRC
46: ) RS,
47: CR_RSRC_DTL RD
48: WHERE RS.RESOURCES = RD.RESOURCES(+)

Line 57: SY_ORGN_MST SY,

53: GROUP BY
54: A.ORGN_CODE,a.resources,trunc(trans_date)
55: ) RSRC,
56: EDW_LOCAL_INSTANCE inst,
57: SY_ORGN_MST SY,
58: GL_PLCY_MST GPM,
59: OPI_PMI_UOMS_MST UOM
60: WHERE PCPND.orgn_code(+)= RSRC.ORGN_CODE and
61: PCPND.trans_date(+)=RSRC.trans_date and

Line 120: FROM SY_ORGN_MST;

116: SELECT avg(nvl(vsize(UOM_CODE), 0))
117: FROM OPI_PMI_UOMS_MST;
118: CURSOR LOC_PK is
119: SELECT avg(nvl(vsize(ORGN_CODE), 0))
120: FROM SY_ORGN_MST;
121:
122: CURSOR TRX_DATE_PK is
123: SELECT avg(nvl(vsize(substr(edw_time_pkg.cal_day_fk
124: (BH.TRANS_DATE,SOB.SET_OF_BOOKS_ID),1,120)),0))

Line 127: SY_ORGN_MST OM,

123: SELECT avg(nvl(vsize(substr(edw_time_pkg.cal_day_fk
124: (BH.TRANS_DATE,SOB.SET_OF_BOOKS_ID),1,120)),0))
125: FROM
126: PC_TRAN_PND BH,
127: SY_ORGN_MST OM,
128: GL_PLCY_MST PM,
129: GL_SETS_OF_BOOKS SOB
130: WHERE
131: BH.ORGN_CODE = OM.ORGN_CODE