APPS.MRP_KANBAN_SNAPSHOT_PK dependencies on ENG_REVISED_ITEMS

Line 862: 'FROM eng_revised_items eri ' ||

858: 'AND bic2.effectivity_date > mrp_bic.effectivity_date ' ||
859: 'AND (bic2.implementation_date is not null OR ' ||
860: '(bic2.implementation_date is null AND EXISTS ' ||
861: '(SELECT NULL ' ||
862: 'FROM eng_revised_items eri ' ||
863: 'WHERE bic2.revised_item_sequence_id = ' ||
864: 'eri.revised_item_sequence_id ' ||
865: 'AND eri.mrp_active = 1 )))) ' ||
866: 'AND (mrp_bic.implementation_date is not null OR ' ||

Line 869: 'FROM eng_revised_items eri ' ||

865: 'AND eri.mrp_active = 1 )))) ' ||
866: 'AND (mrp_bic.implementation_date is not null OR ' ||
867: '(mrp_bic.implementation_date is null AND EXISTS ' ||
868: '(SELECT NULL ' ||
869: 'FROM eng_revised_items eri ' ||
870: 'WHERE mrp_bic.revised_item_sequence_id = ' ||
871: 'eri.revised_item_sequence_id ' ||
872: 'AND eri.mrp_active = 1 ))) ';
873: end if;

Line 1179: FROM eng_revised_items eri

1175: AND bic2.effectivity_date > mrp_bic.effectivity_date
1176: AND (bic2.implementation_date is not null OR
1177: (bic2.implementation_date is null AND EXISTS
1178: (SELECT NULL
1179: FROM eng_revised_items eri
1180: WHERE bic2.revised_item_sequence_id =
1181: eri.revised_item_sequence_id
1182: AND eri.mrp_active = 1 ))))
1183: AND (mrp_bic.implementation_date is not null OR

Line 1186: FROM eng_revised_items eri

1182: AND eri.mrp_active = 1 ))))
1183: AND (mrp_bic.implementation_date is not null OR
1184: (mrp_bic.implementation_date is null AND EXISTS
1185: (SELECT NULL
1186: FROM eng_revised_items eri
1187: WHERE mrp_bic.revised_item_sequence_id =
1188: eri.revised_item_sequence_id
1189: AND eri.mrp_active = 1 )))
1190: AND bbom.common_bill_sequence_id = mrp_bic.bill_sequence_id

Line 1315: FROM eng_revised_items eri

1311: AND bic2.effectivity_date > mrp_bic.effectivity_date
1312: AND (bic2.implementation_date is not null OR
1313: (bic2.implementation_date is null AND EXISTS
1314: (SELECT NULL
1315: FROM eng_revised_items eri
1316: WHERE bic2.revised_item_sequence_id =
1317: eri.revised_item_sequence_id
1318: AND eri.mrp_active = 1 ))))
1319: AND (mrp_bic.implementation_date is not null OR

Line 1322: FROM eng_revised_items eri

1318: AND eri.mrp_active = 1 ))))
1319: AND (mrp_bic.implementation_date is not null OR
1320: (mrp_bic.implementation_date is null AND EXISTS
1321: (SELECT NULL
1322: FROM eng_revised_items eri
1323: WHERE mrp_bic.revised_item_sequence_id =
1324: eri.revised_item_sequence_id
1325: AND eri.mrp_active = 1 )))
1326: AND bor.organization_id = bbom.organization_id