[Home] [Help]
2178: bom_calendar_dates cal,
2179: mtl_system_items msi, /* PARENT */
2180: mtl_system_items msi2, /* CHILD */
2181: bom_inventory_components bic,
2182: eng_revised_items eri,
2183: bom_bill_of_materials bom,
2184: mtl_parameters mp,
2185: bom_explosion_temp be
2186: where be.sort_order <> 3 -- 1288823
2223: and bic.effectivity_date =
2224: (select
2225: max(effectivity_date)
2226: from bom_inventory_components bic1,
2227: eng_revised_items eri
2228: where bic1.bill_sequence_id = bic.bill_sequence_id
2229: and bic1.component_item_id = bic.component_item_id
2230: and bic1.revised_item_sequence_id =
2231: eri.revised_item_sequence_id (+)
2245: and ( nvl(eri.status_type,6) IN (4,6,7))
2246: and not exists
2247: (select
2248: 'X'
2249: from bom_inventory_components bicn, eng_revised_items eri1
2250: where bicn.bill_sequence_id + 0 = bic.bill_sequence_id
2251: and bicn.old_component_sequence_id =
2252: bic.component_sequence_id
2253: and bicn.acd_type in (2,3)
2585: bom_calendar_dates cal,
2586: mtl_system_items msi,
2587: mtl_system_items msi2,
2588: bom_inventory_components bic,
2589: eng_revised_items eri,
2590: bom_bill_of_materials bom,
2591: mtl_parameters mp,
2592: bom_explosion_temp be
2593: where be.sort_order <> 3
2627: and bic.effectivity_date =
2628: (select
2629: max(effectivity_date)
2630: from bom_inventory_components bic1,
2631: eng_revised_items eri
2632: where bic1.bill_sequence_id = bic.bill_sequence_id
2633: and bic1.component_item_id = bic.component_item_id
2634: and bic1.revised_item_sequence_id =
2635: eri.revised_item_sequence_id (+)
2646: and ( nvl(eri.status_type,6) IN (4,6,7))
2647: and not exists
2648: (select
2649: 'X'
2650: from bom_inventory_components bicn, eng_revised_items eri1
2651: where bicn.bill_sequence_id + 0 = bic.bill_sequence_id
2652: and bicn.old_component_sequence_id =
2653: bic.component_sequence_id
2654: and bicn.acd_type in (2,3)
3118: bom_calendar_dates cal,
3119: mtl_system_items msi, /* PARENT */
3120: mtl_system_items msi2, /* CHILD [BUG#1518894] */
3121: bom_inventory_components bic,
3122: eng_revised_items eri,
3123: bom_bill_of_materials bom,
3124: mtl_parameters mp,
3125: bom_explosion_temp be
3126: where be.sort_order <> 3
3162: and bic.effectivity_date =
3163: (select
3164: max(effectivity_date)
3165: from bom_inventory_components bic1,
3166: eng_revised_items eri
3167: where bic1.bill_sequence_id = bic.bill_sequence_id
3168: and bic1.component_item_id = bic.component_item_id
3169: and bic1.revised_item_sequence_id =
3170: eri.revised_item_sequence_id (+)
3183: and ( nvl(eri.status_type,6) IN (4,6,7))
3184: and not exists
3185: (select
3186: 'X'
3187: from bom_inventory_components bicn, eng_revised_items eri1
3188: where bicn.bill_sequence_id + 0 = bic.bill_sequence_id
3189: and bicn.old_component_sequence_id =
3190: bic.component_sequence_id
3191: and bicn.acd_type in (2,3)
3532: bom_calendar_dates cal,
3533: mtl_system_items msi,
3534: mtl_system_items msi2,
3535: bom_inventory_components bic,
3536: eng_revised_items eri,
3537: bom_bill_of_materials bom,
3538: mtl_parameters mp,
3539: bom_explosion_temp be
3540: where be.sort_order <> 3
3574: and bic.effectivity_date =
3575: (select
3576: max(effectivity_date)
3577: from bom_inventory_components bic1,
3578: eng_revised_items eri
3579: where bic1.bill_sequence_id = bic.bill_sequence_id
3580: and bic1.component_item_id = bic.component_item_id
3581: and bic1.revised_item_sequence_id =
3582: eri.revised_item_sequence_id (+)
3593: and ( nvl(eri.status_type,6) IN (4,6,7))
3594: and not exists
3595: (select
3596: 'X'
3597: from bom_inventory_components bicn, eng_revised_items eri1
3598: where bicn.bill_sequence_id + 0 = bic.bill_sequence_id
3599: and bicn.old_component_sequence_id =
3600: bic.component_sequence_id
3601: and bicn.acd_type in (2,3)