DBA Data[Home] [Help]

APPS.OPI_EDW_JOB_RSRC_FOPM_SZ dependencies on EDW_TIME_PKG

Line 176: SELECT avg(nvl(vsize(substr(edw_time_pkg.cal_day_fk

172: SELECT avg(nvl(vsize(ORGN_CODE), 0))
173: FROM SY_ORGN_MST;
174:
175: CURSOR TRX_DATE_PK is
176: SELECT avg(nvl(vsize(substr(edw_time_pkg.cal_day_fk
177: (POD.ACTUAL_CMPLT_DATE,SOB.SET_OF_BOOKS_ID),1,120)),0))
178: FROM
179: PM_OPRN_DTL POD,
180: PM_BTCH_HDR BH,