APPS.INV_MATERIAL_STATUS_PKG dependencies on MTL_RESERVATIONS

Line 609: FROM mtl_reservations mr

605: WHERE organization_id = cp_organization_id
606: AND subinventory_code = cp_subinventory_code
607: AND EXISTS
608: (SELECT 1
609: FROM mtl_reservations mr
610: WHERE mr.inventory_item_id = moq.inventory_item_id
611: AND mr.organization_id = moq.organization_id
612: AND ( (mr.inventory_item_id = cp_inventory_item_id )
613: OR cp_inventory_item_id IS NULL

Line 629: FROM mtl_reservations mr

625: WHERE organization_id = cp_organization_id
626: AND locator_id = cp_locator_id
627: AND EXISTS
628: (SELECT 1
629: FROM mtl_reservations mr
630: WHERE mr.inventory_item_id = moq.inventory_item_id
631: AND mr.organization_id = moq.organization_id
632: AND ( (mr.inventory_item_id = cp_inventory_item_id )
633: OR cp_inventory_item_id IS NULL

Line 645: CURSOR c_lot_items( cp_organization_id mtl_reservations.organization_id%TYPE,

641: )
642: )
643: AND ROWNUM = 1;
644:
645: CURSOR c_lot_items( cp_organization_id mtl_reservations.organization_id%TYPE,
646: cp_inventory_item_id mtl_reservations. inventory_item_id %TYPE,
647: cp_lot_number mtl_onhand_quantities_detail.lot_number%TYPE) IS
648: SELECT 1 FROM mtl_onhand_quantities_detail moq
649: WHERE organization_id = cp_organization_id

Line 646: cp_inventory_item_id mtl_reservations. inventory_item_id %TYPE,

642: )
643: AND ROWNUM = 1;
644:
645: CURSOR c_lot_items( cp_organization_id mtl_reservations.organization_id%TYPE,
646: cp_inventory_item_id mtl_reservations. inventory_item_id %TYPE,
647: cp_lot_number mtl_onhand_quantities_detail.lot_number%TYPE) IS
648: SELECT 1 FROM mtl_onhand_quantities_detail moq
649: WHERE organization_id = cp_organization_id
650: AND (inventory_item_id = cp_inventory_item_id OR cp_inventory_item_id IS NULL)

Line 654: FROM mtl_reservations mr

650: AND (inventory_item_id = cp_inventory_item_id OR cp_inventory_item_id IS NULL)
651: AND lot_number = cp_lot_number
652: AND EXISTS
653: (SELECT 1
654: FROM mtl_reservations mr
655: WHERE mr.inventory_item_id = moq.inventory_item_id
656: AND mr.organization_id = moq.organization_id
657: AND ( (mr.inventory_item_id = cp_inventory_item_id )
658: OR cp_inventory_item_id IS NULL

Line 666: CURSOR c_items_reserv( cp_organization_id mtl_reservations.organization_id%TYPE,

662: )
663: )
664: AND ROWNUM = 1;
665:
666: CURSOR c_items_reserv( cp_organization_id mtl_reservations.organization_id%TYPE,
667: cp_inventory_item_id mtl_reservations. inventory_item_id%TYPE) IS
668: SELECT 1 FROM mtl_reservations
669: WHERE inventory_item_id = cp_inventory_item_id
670: AND organization_id = cp_organization_id

Line 667: cp_inventory_item_id mtl_reservations. inventory_item_id%TYPE) IS

663: )
664: AND ROWNUM = 1;
665:
666: CURSOR c_items_reserv( cp_organization_id mtl_reservations.organization_id%TYPE,
667: cp_inventory_item_id mtl_reservations. inventory_item_id%TYPE) IS
668: SELECT 1 FROM mtl_reservations
669: WHERE inventory_item_id = cp_inventory_item_id
670: AND organization_id = cp_organization_id
671: AND ROWNUM = 1;

Line 668: SELECT 1 FROM mtl_reservations

664: AND ROWNUM = 1;
665:
666: CURSOR c_items_reserv( cp_organization_id mtl_reservations.organization_id%TYPE,
667: cp_inventory_item_id mtl_reservations. inventory_item_id%TYPE) IS
668: SELECT 1 FROM mtl_reservations
669: WHERE inventory_item_id = cp_inventory_item_id
670: AND organization_id = cp_organization_id
671: AND ROWNUM = 1;
672: