APPS.WIP_PICKING_PUB dependencies on INV_GLOBALS

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

562: and inventory_item_id = p_inventory_item_id;
563: end if;
564:
565: begin
566: if (l_txn_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_WIP_ISSUE) then
567: select sum(nvl(mtrl.quantity,0) - nvl(mtrl.quantity_delivered,0))
568: into l_quantity_allocated
569: from MTL_TXN_REQUEST_LINES mtrl
570: where

Line 578: mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED

574: mtrl.reference_id = p_repetitive_schedule_id) and
575: mtrl.organization_id = p_organization_id and
576: mtrl.INVENTORY_ITEM_ID = p_inventory_item_id and
577: -- preapproved status or open lines
578: mtrl.line_status = INV_GLOBALS.G_TO_STATUS_PREAPPROVED
579: group by mtrl.organization_id, mtrl.TXN_SOURCE_ID,
580: mtrl.TXN_SOURCE_LINE_ID, mtrl.INVENTORY_ITEM_ID;
581: else
582: select sum(nvl(mtrl.quantity,0))

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

588: ( p_repetitive_schedule_id is null or
589: mtrl.reference_id = p_repetitive_schedule_id) and
590: mtrl.organization_id = p_organization_id and
591: mtrl.INVENTORY_ITEM_ID = p_inventory_item_id and
592: mtrl.line_status in (INV_GLOBALS.G_TO_STATUS_CLOSED,
593: INV_GLOBALS.G_TO_STATUS_PREAPPROVED) -- preapproved or closed
594: group by mtrl.organization_id, mtrl.TXN_SOURCE_ID,
595: mtrl.TXN_SOURCE_LINE_ID, mtrl.INVENTORY_ITEM_ID;
596:

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

589: mtrl.reference_id = p_repetitive_schedule_id) and
590: mtrl.organization_id = p_organization_id and
591: mtrl.INVENTORY_ITEM_ID = p_inventory_item_id and
592: mtrl.line_status in (INV_GLOBALS.G_TO_STATUS_CLOSED,
593: INV_GLOBALS.G_TO_STATUS_PREAPPROVED) -- preapproved or closed
594: group by mtrl.organization_id, mtrl.TXN_SOURCE_ID,
595: mtrl.TXN_SOURCE_LINE_ID, mtrl.INVENTORY_ITEM_ID;
596:
597: /* Start for the Fix for Bug#5468293.

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

615: mtrl.reference_id = p_repetitive_schedule_id) and
616: mtrl.crossdock_type = 2 and -- WIP
617: mtrl.organization_id = p_organization_id and
618: mtrl.INVENTORY_ITEM_ID = p_inventory_item_id and
619: mtrl.line_status in (INV_GLOBALS.G_TO_STATUS_CLOSED,
620: INV_GLOBALS.G_TO_STATUS_PREAPPROVED)) ; -- preapproved or closed
621:
622: select quantity_allocated
623: into l_wro_quantity_allocated

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

616: mtrl.crossdock_type = 2 and -- WIP
617: mtrl.organization_id = p_organization_id and
618: mtrl.INVENTORY_ITEM_ID = p_inventory_item_id and
619: mtrl.line_status in (INV_GLOBALS.G_TO_STATUS_CLOSED,
620: INV_GLOBALS.G_TO_STATUS_PREAPPROVED)) ; -- preapproved or closed
621:
622: select quantity_allocated
623: into l_wro_quantity_allocated
624: from wip_requirement_operations