[Home] [Help]
2271: bom_calendar_dates cal,
2272: mtl_system_items msi, /* PARENT */
2273: mtl_system_items msi2, /* CHILD */
2274: bom_inventory_components bic,
2275: eng_revised_items eri,
2276: bom_bill_of_materials bom,
2277: mtl_parameters mp,
2278: bom_explosion_temp be
2279: where be.sort_order <> 3 -- 1288823
2316: and bic.effectivity_date =
2317: (select
2318: max(effectivity_date)
2319: from bom_inventory_components bic1,
2320: eng_revised_items eri
2321: where bic1.bill_sequence_id = bic.bill_sequence_id
2322: and bic1.component_item_id = bic.component_item_id
2323: and bic1.revised_item_sequence_id =
2324: eri.revised_item_sequence_id (+)
2338: and ( nvl(eri.status_type,6) IN (4,6,7))
2339: and not exists
2340: (select
2341: 'X'
2342: from bom_inventory_components bicn, eng_revised_items eri1
2343: where bicn.bill_sequence_id + 0 = bic.bill_sequence_id
2344: and bicn.old_component_sequence_id =
2345: bic.component_sequence_id
2346: and bicn.acd_type in (2,3)
2678: bom_calendar_dates cal,
2679: mtl_system_items msi,
2680: mtl_system_items msi2,
2681: bom_inventory_components bic,
2682: eng_revised_items eri,
2683: bom_bill_of_materials bom,
2684: mtl_parameters mp,
2685: bom_explosion_temp be
2686: where be.sort_order <> 3
2720: and bic.effectivity_date =
2721: (select
2722: max(effectivity_date)
2723: from bom_inventory_components bic1,
2724: eng_revised_items eri
2725: where bic1.bill_sequence_id = bic.bill_sequence_id
2726: and bic1.component_item_id = bic.component_item_id
2727: and bic1.revised_item_sequence_id =
2728: eri.revised_item_sequence_id (+)
2739: and ( nvl(eri.status_type,6) IN (4,6,7))
2740: and not exists
2741: (select
2742: 'X'
2743: from bom_inventory_components bicn, eng_revised_items eri1
2744: where bicn.bill_sequence_id + 0 = bic.bill_sequence_id
2745: and bicn.old_component_sequence_id =
2746: bic.component_sequence_id
2747: and bicn.acd_type in (2,3)
3211: bom_calendar_dates cal,
3212: mtl_system_items msi, /* PARENT */
3213: mtl_system_items msi2, /* CHILD [BUG#1518894] */
3214: bom_inventory_components bic,
3215: eng_revised_items eri,
3216: bom_bill_of_materials bom,
3217: mtl_parameters mp,
3218: bom_explosion_temp be
3219: where be.sort_order <> 3
3255: and bic.effectivity_date =
3256: (select
3257: max(effectivity_date)
3258: from bom_inventory_components bic1,
3259: eng_revised_items eri
3260: where bic1.bill_sequence_id = bic.bill_sequence_id
3261: and bic1.component_item_id = bic.component_item_id
3262: and bic1.revised_item_sequence_id =
3263: eri.revised_item_sequence_id (+)
3276: and ( nvl(eri.status_type,6) IN (4,6,7))
3277: and not exists
3278: (select
3279: 'X'
3280: from bom_inventory_components bicn, eng_revised_items eri1
3281: where bicn.bill_sequence_id + 0 = bic.bill_sequence_id
3282: and bicn.old_component_sequence_id =
3283: bic.component_sequence_id
3284: and bicn.acd_type in (2,3)
3625: bom_calendar_dates cal,
3626: mtl_system_items msi,
3627: mtl_system_items msi2,
3628: bom_inventory_components bic,
3629: eng_revised_items eri,
3630: bom_bill_of_materials bom,
3631: mtl_parameters mp,
3632: bom_explosion_temp be
3633: where be.sort_order <> 3
3667: and bic.effectivity_date =
3668: (select
3669: max(effectivity_date)
3670: from bom_inventory_components bic1,
3671: eng_revised_items eri
3672: where bic1.bill_sequence_id = bic.bill_sequence_id
3673: and bic1.component_item_id = bic.component_item_id
3674: and bic1.revised_item_sequence_id =
3675: eri.revised_item_sequence_id (+)
3686: and ( nvl(eri.status_type,6) IN (4,6,7))
3687: and not exists
3688: (select
3689: 'X'
3690: from bom_inventory_components bicn, eng_revised_items eri1
3691: where bicn.bill_sequence_id + 0 = bic.bill_sequence_id
3692: and bicn.old_component_sequence_id =
3693: bic.component_sequence_id
3694: and bicn.acd_type in (2,3)