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 1178: FROM eng_revised_items eri

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

Line 1185: FROM eng_revised_items eri

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

Line 1314: FROM eng_revised_items eri

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

Line 1321: FROM eng_revised_items eri

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