APPS.OPI_EDW_OPM_JOB_RSRC_F_C dependencies on PM_OPRN_DTL

Line 62: PM_OPRN_DTL.BATCHSTEP_NO - PM_OPRN_DTL.RESOURCES - PM_OPRN_DTL.ACTIVITY

58: edw_log.put_line (' ');
59: edw_log.put_line (' ');
60:
61: edw_log.put_line ('Primary Key is PM_BTCH_HDR.Batch_id - PM_MATL_DTL.line_id -
62: PM_OPRN_DTL.BATCHSTEP_NO - PM_OPRN_DTL.RESOURCES - PM_OPRN_DTL.ACTIVITY
63: - PM_OPRN_DTL.BATCHSTEPLINE_ID - instance_code - OPM');
64: edw_log.put_line ('-----------------------------------------');
65: edw_log.put_line ('Primary Key / Currency / Transaction Date');
66: edw_log.put_line ('-----------------------------------------');

Line 63: - PM_OPRN_DTL.BATCHSTEPLINE_ID - instance_code - OPM');

59: edw_log.put_line (' ');
60:
61: edw_log.put_line ('Primary Key is PM_BTCH_HDR.Batch_id - PM_MATL_DTL.line_id -
62: PM_OPRN_DTL.BATCHSTEP_NO - PM_OPRN_DTL.RESOURCES - PM_OPRN_DTL.ACTIVITY
63: - PM_OPRN_DTL.BATCHSTEPLINE_ID - instance_code - OPM');
64: edw_log.put_line ('-----------------------------------------');
65: edw_log.put_line ('Primary Key / Currency / Transaction Date');
66: edw_log.put_line ('-----------------------------------------');
67: /* Print Rows */

Line 104: PM_OPRN_DTL

100: BATCHSTEPLINE_ID,
101: 1,
102: NULL
103: FROM
104: PM_OPRN_DTL
105: WHERE
106: BATCHSTEPLINE_ID
107: in ( SELECT SUBSTRB(JOB_RSRC_PK,instrB(JOB_RSRC_PK,'-',-1,3)+1,
108: instrB(JOB_RSRC_PK,'-',-1,2)-1-instrB(JOB_RSRC_PK,'-',-1,3))

Line 322: PM_OPRN_DTL POD,

318: BATCHSTEPLINE_ID,
319: 1,
320: l_seq_id
321: FROM
322: PM_OPRN_DTL POD,
323: PM_BTCH_HDR PBH
324: WHERE POD.BATCH_ID=PBH.BATCH_ID
325: AND GREATEST(POD.LAST_UPDATE_DATE, PBH.LAST_UPDATE_DATE)
326: BETWEEN g_push_from_date and g_push_to_date