APPS.WIP_PICKING_PUB dependencies on INV_GLOBALS

Line 575: if (l_txn_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_WIP_ISSUE) then

571: and inventory_item_id = p_inventory_item_id;
572: end if;
573:
574: begin
575: if (l_txn_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_WIP_ISSUE) then
576: select sum(nvl(mtrl.quantity,0) - nvl(mtrl.quantity_delivered,0))
577: into l_quantity_allocated
578: from MTL_TXN_REQUEST_LINES mtrl
579: where

Line 587: mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

583: mtrl.reference_id = p_repetitive_schedule_id) and
584: mtrl.organization_id = p_organization_id and
585: mtrl.INVENTORY_ITEM_ID = p_inventory_item_id and
586: -- preapproved status or open lines
587: mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED
588: group by mtrl.organization_id, mtrl.TXN_SOURCE_ID,
589: mtrl.TXN_SOURCE_LINE_ID, mtrl.INVENTORY_ITEM_ID;
590: else
591: select sum(nvl(mtrl.quantity,0))

Line 601: mtrl.line_status in (INV_GLOBALS.G_TO_STATUS_CLOSED,

597: ( p_repetitive_schedule_id is null or
598: mtrl.reference_id = p_repetitive_schedule_id) and
599: mtrl.organization_id = p_organization_id and
600: mtrl.INVENTORY_ITEM_ID = p_inventory_item_id and
601: mtrl.line_status in (INV_GLOBALS.G_TO_STATUS_CLOSED,
602: INV_GLOBALS.G_TO_STATUS_PREAPPROVED) -- preapproved or closed
603: group by mtrl.organization_id, mtrl.TXN_SOURCE_ID,
604: mtrl.TXN_SOURCE_LINE_ID, mtrl.INVENTORY_ITEM_ID;
605:

Line 602: INV_GLOBALS.G_TO_STATUS_PREAPPROVED) -- preapproved or closed

598: mtrl.reference_id = p_repetitive_schedule_id) and
599: mtrl.organization_id = p_organization_id and
600: mtrl.INVENTORY_ITEM_ID = p_inventory_item_id and
601: mtrl.line_status in (INV_GLOBALS.G_TO_STATUS_CLOSED,
602: INV_GLOBALS.G_TO_STATUS_PREAPPROVED) -- preapproved or closed
603: group by mtrl.organization_id, mtrl.TXN_SOURCE_ID,
604: mtrl.TXN_SOURCE_LINE_ID, mtrl.INVENTORY_ITEM_ID;
605:
606: /* Start for the Fix for Bug#5468293.

Line 628: mtrl.line_status in (INV_GLOBALS.G_TO_STATUS_CLOSED,

624: mtrl.reference_id = p_repetitive_schedule_id) and
625: mtrl.crossdock_type = 2 and -- WIP
626: mtrl.organization_id = p_organization_id and
627: mtrl.INVENTORY_ITEM_ID = p_inventory_item_id and
628: mtrl.line_status in (INV_GLOBALS.G_TO_STATUS_CLOSED,
629: INV_GLOBALS.G_TO_STATUS_PREAPPROVED)) ; -- preapproved or closed
630:
631: select quantity_allocated
632: into l_wro_quantity_allocated

Line 629: INV_GLOBALS.G_TO_STATUS_PREAPPROVED)) ; -- preapproved or closed

625: mtrl.crossdock_type = 2 and -- WIP
626: mtrl.organization_id = p_organization_id and
627: mtrl.INVENTORY_ITEM_ID = p_inventory_item_id and
628: mtrl.line_status in (INV_GLOBALS.G_TO_STATUS_CLOSED,
629: INV_GLOBALS.G_TO_STATUS_PREAPPROVED)) ; -- preapproved or closed
630:
631: select quantity_allocated
632: into l_wro_quantity_allocated
633: from wip_requirement_operations