DBA Data[Home] [Help]

APPS.MRP_KANBAN_PLAN_PK dependencies on ENG_REVISED_ITEMS

Line 983: FROM eng_revised_items eri

979: AND bic2.effectivity_date > bic.effectivity_date
980: AND (bic2.implementation_date is not null OR
981: (bic2.implementation_date is null AND EXISTS
982: (SELECT NULL
983: FROM eng_revised_items eri
984: WHERE bic2.revised_item_sequence_id =
985: eri.revised_item_sequence_id
986: AND eri.mrp_active = 1 ))))
987: AND (bic.implementation_date is not null OR

Line 990: FROM eng_revised_items eri

986: AND eri.mrp_active = 1 ))))
987: AND (bic.implementation_date is not null OR
988: (bic.implementation_date is null AND EXISTS
989: (SELECT NULL
990: FROM eng_revised_items eri
991: WHERE bic.revised_item_sequence_id =
992: eri.revised_item_sequence_id
993: AND eri.mrp_active = 1 )))
994: AND mllc.plan_id = g_kanban_info_rec.kanban_plan_id

Line 1552: FROM eng_revised_items eri

1548: AND bic2.effectivity_date > bic.effectivity_date
1549: AND (bic2.implementation_date is not null OR
1550: (bic2.implementation_date is null AND EXISTS
1551: (SELECT NULL
1552: FROM eng_revised_items eri
1553: WHERE bic2.revised_item_sequence_id =
1554: eri.revised_item_sequence_id
1555: AND eri.mrp_active = 1 ))))
1556: AND (bic.implementation_date is not null OR

Line 1559: FROM eng_revised_items eri

1555: AND eri.mrp_active = 1 ))))
1556: AND (bic.implementation_date is not null OR
1557: (bic.implementation_date is null AND EXISTS
1558: (SELECT NULL
1559: FROM eng_revised_items eri
1560: WHERE bic.revised_item_sequence_id =
1561: eri.revised_item_sequence_id
1562: AND eri.mrp_active = 1 )))
1563: AND mllc.plan_id = g_kanban_info_rec.kanban_plan_id

Line 2057: FROM eng_revised_items eri

2053: AND bic2.effectivity_date > bic.effectivity_date
2054: AND (bic2.implementation_date is not null OR
2055: (bic2.implementation_date is null AND EXISTS
2056: (SELECT NULL
2057: FROM eng_revised_items eri
2058: WHERE bic2.revised_item_sequence_id =
2059: eri.revised_item_sequence_id
2060: AND eri.mrp_active = 1 ))))
2061: AND (bic.implementation_date is not null OR

Line 2064: FROM eng_revised_items eri

2060: AND eri.mrp_active = 1 ))))
2061: AND (bic.implementation_date is not null OR
2062: (bic.implementation_date is null AND EXISTS
2063: (SELECT NULL
2064: FROM eng_revised_items eri
2065: WHERE bic.revised_item_sequence_id =
2066: eri.revised_item_sequence_id
2067: AND eri.mrp_active = 1 )))
2068: AND mllc.plan_id = g_kanban_info_rec.kanban_plan_id