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