APPS.WIP_PICKING_PUB dependencies on WIP_PARAMETERS

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

886: where wip_entity_id = p_wip_entity_id
887: and operation_seq_num = p_operation_seq_num
888: and inventory_item_id = NVL(p_inventory_item_id, inventory_item_id)
889: and (
890: ('Y' = (select allocate_backflush_components from wip_parameters wp
891: where organization_id = wro.organization_id)
892: and wip_supply_type in
893: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
894: or wip_supply_type = wip_constants.push

Line 909: from wip_parameters wp

905: and p_repetitive_schedule_id = p_repetitive_schedule_id
906: and inventory_item_id = NVL(p_inventory_item_id, inventory_item_id)
907: and (
908: ('Y' = (select allocate_backflush_components
909: from wip_parameters wp
910: where organization_id = wro.organization_id)
911: and wip_supply_type in
912: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
913: or wip_supply_type = wip_constants.push

Line 965: from wip_parameters wp

961: where wip_entity_id=p_wip_entity_id
962: and quantity_backordered is not null
963: and (
964: ('Y' = (select allocate_backflush_components
965: from wip_parameters wp
966: where organization_id = wro.organization_id)
967: and wip_supply_type in
968: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
969: or wip_supply_type = wip_constants.push

Line 982: from wip_parameters wp

978: and repetitive_schedule_id = p_repetitive_schedule_id
979: and quantity_backordered is not null
980: and (
981: ('Y' = (select allocate_backflush_components
982: from wip_parameters wp
983: where organization_id = wro.organization_id)
984: and wro.wip_supply_type in
985: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
986: or wro.wip_supply_type = wip_constants.push