APPS.OPI_EDW_RES_UTIL_FOPM_SZ dependencies on PC_TRAN_PND

Line 18: PC_TRAN_PND

14: ORGN_CODE,
15: trunc(trans_date) trans_date ,
16: resources,sum(resource_usage) RSRC_USAGE
17: FROM
18: PC_TRAN_PND
19: WHERE completed_ind=1
20: GROUP BY
21: ORGN_CODE,trunc(trans_date),resources
22: ) PCPND,

Line 51: PC_TRAN_PND b

47: CR_RSRC_DTL RD
48: WHERE RS.RESOURCES = RD.RESOURCES(+)
49: AND RS.ORGN_CODE = RD.ORGN_CODE(+)
50: ) a,
51: PC_TRAN_PND b
52: WHERE b.completed_ind=1
53: GROUP BY
54: A.ORGN_CODE,a.resources,trunc(trans_date)
55: ) RSRC,

Line 99: PC_TRAN_PND RSRC

95: SELECT
96: avg(nvl(vsize(RSRC.TRANS_DATE||'-'||rsrc.ORGN_CODE||'-'||RSRC.RESOURCES||'-OPM'),0)) RES_UTIL_PK,
97: avg(nvl(vsize(RESOURCE_USAGE),0))
98: FROM
99: PC_TRAN_PND RSRC
100: WHERE
101: last_update_date between
102: p_from_date and p_to_date;
103:

Line 126: PC_TRAN_PND BH,

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))
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