DBA Data[Home] [Help]

APPS.MRP_KANBAN_PLAN_PK dependencies on ENG_REVISED_ITEMS

Line 920: FROM eng_revised_items eri

916: AND bic2.effectivity_date > bic.effectivity_date
917: AND (bic2.implementation_date is not null OR
918: (bic2.implementation_date is null AND EXISTS
919: (SELECT NULL
920: FROM eng_revised_items eri
921: WHERE bic2.revised_item_sequence_id =
922: eri.revised_item_sequence_id
923: AND eri.mrp_active = 1 ))))
924: AND (bic.implementation_date is not null OR

Line 927: FROM eng_revised_items eri

923: AND eri.mrp_active = 1 ))))
924: AND (bic.implementation_date is not null OR
925: (bic.implementation_date is null AND EXISTS
926: (SELECT NULL
927: FROM eng_revised_items eri
928: WHERE bic.revised_item_sequence_id =
929: eri.revised_item_sequence_id
930: AND eri.mrp_active = 1 )))
931: AND mllc.plan_id = g_kanban_info_rec.kanban_plan_id

Line 1473: FROM eng_revised_items eri

1469: AND bic2.effectivity_date > bic.effectivity_date
1470: AND (bic2.implementation_date is not null OR
1471: (bic2.implementation_date is null AND EXISTS
1472: (SELECT NULL
1473: FROM eng_revised_items eri
1474: WHERE bic2.revised_item_sequence_id =
1475: eri.revised_item_sequence_id
1476: AND eri.mrp_active = 1 ))))
1477: AND (bic.implementation_date is not null OR

Line 1480: FROM eng_revised_items eri

1476: AND eri.mrp_active = 1 ))))
1477: AND (bic.implementation_date is not null OR
1478: (bic.implementation_date is null AND EXISTS
1479: (SELECT NULL
1480: FROM eng_revised_items eri
1481: WHERE bic.revised_item_sequence_id =
1482: eri.revised_item_sequence_id
1483: AND eri.mrp_active = 1 )))
1484: AND mllc.plan_id = g_kanban_info_rec.kanban_plan_id

Line 1962: FROM eng_revised_items eri

1958: AND bic2.effectivity_date > bic.effectivity_date
1959: AND (bic2.implementation_date is not null OR
1960: (bic2.implementation_date is null AND EXISTS
1961: (SELECT NULL
1962: FROM eng_revised_items eri
1963: WHERE bic2.revised_item_sequence_id =
1964: eri.revised_item_sequence_id
1965: AND eri.mrp_active = 1 ))))
1966: AND (bic.implementation_date is not null OR

Line 1969: FROM eng_revised_items eri

1965: AND eri.mrp_active = 1 ))))
1966: AND (bic.implementation_date is not null OR
1967: (bic.implementation_date is null AND EXISTS
1968: (SELECT NULL
1969: FROM eng_revised_items eri
1970: WHERE bic.revised_item_sequence_id =
1971: eri.revised_item_sequence_id
1972: AND eri.mrp_active = 1 )))
1973: AND mllc.plan_id = g_kanban_info_rec.kanban_plan_id