APPS.OPI_EDW_OPM_JOB_DETAIL_F_C dependencies on PM_MATL_DTL

Line 50: in (select BATCH_ID from PM_MATL_DTL WHERE

46: COLLECTION_STATUS in ('RATE NOT AVAILABLE','INVALID CURRENCY')
47: AND JOB_DETAIL_PK like '%OPM'
48: AND SUBSTRB(JOB_DETAIL_PK,instrB(JOB_DETAIL_PK,'-',1,1)+1,
49: instrB(JOB_DETAIL_PK,'-',1,2)-1-instrB(JOB_DETAIL_PK,'-',1,1))
50: in (select BATCH_ID from PM_MATL_DTL WHERE
51: LINE_ID in (select PRIMARY_KEY from
52: OPI_EDW_OPM_JOB_DETAIL_INC
53: WHERE SEQ_ID is NULL));
54:

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 105: PM_MATL_DTL

101: LINE_ID,
102: 1,
103: NULL
104: FROM
105: PM_MATL_DTL
106: WHERE
107: LINE_TYPE=1 AND
108: BATCH_ID
109: in ( SELECT SUBSTRB(JOB_DETAIL_PK,instrB(JOB_DETAIL_PK,'-',1,1)+1,

Line 377: PM_MATL_DTL BD

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
381: AND GREATEST(BH.LAST_UPDATE_DATE, BD.LAST_UPDATE_DATE)