APPS.WIP_PICKING_PUB dependencies on WIP_PARAMETERS

Line 833: ('Y' = (select allocate_backflush_components from wip_parameters wp

829: where wip_entity_id = p_wip_entity_id
830: and operation_seq_num = p_operation_seq_num
831: and inventory_item_id = NVL(p_inventory_item_id, inventory_item_id)
832: and (
833: ('Y' = (select allocate_backflush_components from wip_parameters wp
834: where organization_id = wro.organization_id)
835: and wip_supply_type in
836: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
837: or wip_supply_type = wip_constants.push

Line 852: from wip_parameters wp

848: and p_repetitive_schedule_id = p_repetitive_schedule_id
849: and inventory_item_id = NVL(p_inventory_item_id, inventory_item_id)
850: and (
851: ('Y' = (select allocate_backflush_components
852: from wip_parameters wp
853: where organization_id = wro.organization_id)
854: and wip_supply_type in
855: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
856: or wip_supply_type = wip_constants.push

Line 908: from wip_parameters wp

904: where wip_entity_id=p_wip_entity_id
905: and quantity_backordered is not null
906: and (
907: ('Y' = (select allocate_backflush_components
908: from wip_parameters wp
909: where organization_id = wro.organization_id)
910: and wip_supply_type in
911: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
912: or wip_supply_type = wip_constants.push

Line 925: from wip_parameters wp

921: and repetitive_schedule_id = p_repetitive_schedule_id
922: and quantity_backordered is not null
923: and (
924: ('Y' = (select allocate_backflush_components
925: from wip_parameters wp
926: where organization_id = wro.organization_id)
927: and wro.wip_supply_type in
928: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
929: or wro.wip_supply_type = wip_constants.push