APPS.OPI_EDW_OPM_JOB_DETAIL_F_C dependencies on PM_BTCH_HDR

Line 63: edw_log.put_line ('Primary Key is PM_BTCH_HDR.Plant_code - PM_BTCH_HDR.Batch_id - PM_MATL_DTL.Item_id - instance_code - OPM');

59:
60: edw_log.put_line (' ');
61: edw_log.put_line (' ');
62:
63: edw_log.put_line ('Primary Key is PM_BTCH_HDR.Plant_code - PM_BTCH_HDR.Batch_id - PM_MATL_DTL.Item_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 376: FROM PM_BTCH_HDR BH,

372: SELECT
373: LINE_ID,
374: 1,
375: l_seq_id
376: FROM PM_BTCH_HDR BH,
377: PM_MATL_DTL BD
378: WHERE BH.BATCH_ID = BD.BATCH_ID
379: AND BH.BATCH_STATUS in (-1,0,1,2,3,4)
380: AND BD.LINE_TYPE=1