DBA Data[Home] [Help]

APPS.OPI_EDW_OPM_JOB_RSRC_F_C dependencies on PM_BTCH_HDR

Line 61: edw_log.put_line ('Primary Key is PM_BTCH_HDR.Batch_id - PM_MATL_DTL.line_id -

57:
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');

Line 323: PM_BTCH_HDR PBH

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
327: AND BATCHSTEPLINE_ID not in (