482: BOM_EXPLOSIONS BE
483: -- FP bug fix for 12.1.1. The bug # is 7307613.
484: -- Fixed by Minling on 10/15/08.
485: -- Changed the WHERE condition to improve performance of the query.
486: WHERE ( ( BBOM_C.obj_name IS NULL AND fnd_global.RESP_APPL_ID = 431 )
487: OR ( BBOM_C.obj_name IS NULL AND fnd_global.RESP_APPL_ID = -1 )
488: OR ( BBOM_C.obj_name is null and fnd_global.RESP_APPL_ID <> 431 and nvl(BBOM_C.effectivity_control,1) <= 3 ) )
489: AND ( ( BOM.obj_name IS NULL AND fnd_global.RESP_APPL_ID = 431 )
490: OR ( BOM.obj_name IS NULL AND fnd_global.RESP_APPL_ID = -1 )
483: -- FP bug fix for 12.1.1. The bug # is 7307613.
484: -- Fixed by Minling on 10/15/08.
485: -- Changed the WHERE condition to improve performance of the query.
486: WHERE ( ( BBOM_C.obj_name IS NULL AND fnd_global.RESP_APPL_ID = 431 )
487: OR ( BBOM_C.obj_name IS NULL AND fnd_global.RESP_APPL_ID = -1 )
488: OR ( BBOM_C.obj_name is null and fnd_global.RESP_APPL_ID <> 431 and nvl(BBOM_C.effectivity_control,1) <= 3 ) )
489: AND ( ( BOM.obj_name IS NULL AND fnd_global.RESP_APPL_ID = 431 )
490: OR ( BOM.obj_name IS NULL AND fnd_global.RESP_APPL_ID = -1 )
491: OR ( BOM.obj_name is null and fnd_global.RESP_APPL_ID <> 431 and nvl(BOM.effectivity_control,1) <= 3 ) )
484: -- Fixed by Minling on 10/15/08.
485: -- Changed the WHERE condition to improve performance of the query.
486: WHERE ( ( BBOM_C.obj_name IS NULL AND fnd_global.RESP_APPL_ID = 431 )
487: OR ( BBOM_C.obj_name IS NULL AND fnd_global.RESP_APPL_ID = -1 )
488: OR ( BBOM_C.obj_name is null and fnd_global.RESP_APPL_ID <> 431 and nvl(BBOM_C.effectivity_control,1) <= 3 ) )
489: AND ( ( BOM.obj_name IS NULL AND fnd_global.RESP_APPL_ID = 431 )
490: OR ( BOM.obj_name IS NULL AND fnd_global.RESP_APPL_ID = -1 )
491: OR ( BOM.obj_name is null and fnd_global.RESP_APPL_ID <> 431 and nvl(BOM.effectivity_control,1) <= 3 ) )
492: AND BE.TOP_BILL_SEQUENCE_ID = x_top_bill_id
485: -- Changed the WHERE condition to improve performance of the query.
486: WHERE ( ( BBOM_C.obj_name IS NULL AND fnd_global.RESP_APPL_ID = 431 )
487: OR ( BBOM_C.obj_name IS NULL AND fnd_global.RESP_APPL_ID = -1 )
488: OR ( BBOM_C.obj_name is null and fnd_global.RESP_APPL_ID <> 431 and nvl(BBOM_C.effectivity_control,1) <= 3 ) )
489: AND ( ( BOM.obj_name IS NULL AND fnd_global.RESP_APPL_ID = 431 )
490: OR ( BOM.obj_name IS NULL AND fnd_global.RESP_APPL_ID = -1 )
491: OR ( BOM.obj_name is null and fnd_global.RESP_APPL_ID <> 431 and nvl(BOM.effectivity_control,1) <= 3 ) )
492: AND BE.TOP_BILL_SEQUENCE_ID = x_top_bill_id
493: -- END of bug fix 7307613.
486: WHERE ( ( BBOM_C.obj_name IS NULL AND fnd_global.RESP_APPL_ID = 431 )
487: OR ( BBOM_C.obj_name IS NULL AND fnd_global.RESP_APPL_ID = -1 )
488: OR ( BBOM_C.obj_name is null and fnd_global.RESP_APPL_ID <> 431 and nvl(BBOM_C.effectivity_control,1) <= 3 ) )
489: AND ( ( BOM.obj_name IS NULL AND fnd_global.RESP_APPL_ID = 431 )
490: OR ( BOM.obj_name IS NULL AND fnd_global.RESP_APPL_ID = -1 )
491: OR ( BOM.obj_name is null and fnd_global.RESP_APPL_ID <> 431 and nvl(BOM.effectivity_control,1) <= 3 ) )
492: AND BE.TOP_BILL_SEQUENCE_ID = x_top_bill_id
493: -- END of bug fix 7307613.
494:
487: OR ( BBOM_C.obj_name IS NULL AND fnd_global.RESP_APPL_ID = -1 )
488: OR ( BBOM_C.obj_name is null and fnd_global.RESP_APPL_ID <> 431 and nvl(BBOM_C.effectivity_control,1) <= 3 ) )
489: AND ( ( BOM.obj_name IS NULL AND fnd_global.RESP_APPL_ID = 431 )
490: OR ( BOM.obj_name IS NULL AND fnd_global.RESP_APPL_ID = -1 )
491: OR ( BOM.obj_name is null and fnd_global.RESP_APPL_ID <> 431 and nvl(BOM.effectivity_control,1) <= 3 ) )
492: AND BE.TOP_BILL_SEQUENCE_ID = x_top_bill_id
493: -- END of bug fix 7307613.
494:
495: