APPS.INV_MATERIAL_STATUS_PKG dependencies on MTL_RESERVATIONS

Line 744: FROM mtl_reservations mr

740: WHERE organization_id = cp_organization_id
741: AND subinventory_code = cp_subinventory_code
742: AND EXISTS
743: (SELECT 1
744: FROM mtl_reservations mr
745: WHERE mr.inventory_item_id = moq.inventory_item_id
746: AND mr.organization_id = moq.organization_id
747: /* Bug 8674685
748: AND ( (mr.inventory_item_id = cp_inventory_item_id )

Line 766: FROM mtl_reservations mr

762: WHERE organization_id = cp_organization_id
763: AND locator_id = cp_locator_id
764: AND EXISTS
765: (SELECT 1
766: FROM mtl_reservations mr
767: WHERE mr.inventory_item_id = moq.inventory_item_id
768: AND mr.organization_id = moq.organization_id
769: /* Bug 8674685
770: AND ( (mr.inventory_item_id = cp_inventory_item_id )

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

780: )
781: )
782: AND ROWNUM = 1;
783:
784: CURSOR c_lot_items( cp_organization_id mtl_reservations.organization_id%TYPE,
785: cp_inventory_item_id mtl_reservations. inventory_item_id %TYPE,
786: cp_lot_number mtl_onhand_quantities_detail.lot_number%TYPE) IS
787: SELECT 1 FROM mtl_onhand_quantities_detail moq
788: WHERE organization_id = cp_organization_id

Line 785: cp_inventory_item_id mtl_reservations. inventory_item_id %TYPE,

781: )
782: AND ROWNUM = 1;
783:
784: CURSOR c_lot_items( cp_organization_id mtl_reservations.organization_id%TYPE,
785: cp_inventory_item_id mtl_reservations. inventory_item_id %TYPE,
786: cp_lot_number mtl_onhand_quantities_detail.lot_number%TYPE) IS
787: SELECT 1 FROM mtl_onhand_quantities_detail moq
788: WHERE organization_id = cp_organization_id
789: AND (inventory_item_id = cp_inventory_item_id OR cp_inventory_item_id IS NULL)

Line 793: FROM mtl_reservations mr

789: AND (inventory_item_id = cp_inventory_item_id OR cp_inventory_item_id IS NULL)
790: AND lot_number = cp_lot_number
791: AND EXISTS
792: (SELECT 1
793: FROM mtl_reservations mr
794: WHERE mr.inventory_item_id = moq.inventory_item_id
795: AND mr.organization_id = moq.organization_id
796: AND ( (mr.inventory_item_id = cp_inventory_item_id )
797: OR cp_inventory_item_id IS NULL

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

801: )
802: )
803: AND ROWNUM = 1;
804:
805: CURSOR c_items_reserv( cp_organization_id mtl_reservations.organization_id%TYPE,
806: cp_inventory_item_id mtl_reservations. inventory_item_id%TYPE) IS
807: SELECT 1 FROM mtl_reservations
808: WHERE inventory_item_id = cp_inventory_item_id
809: AND organization_id = cp_organization_id

Line 806: cp_inventory_item_id mtl_reservations. inventory_item_id%TYPE) IS

802: )
803: AND ROWNUM = 1;
804:
805: CURSOR c_items_reserv( cp_organization_id mtl_reservations.organization_id%TYPE,
806: cp_inventory_item_id mtl_reservations. inventory_item_id%TYPE) IS
807: SELECT 1 FROM mtl_reservations
808: WHERE inventory_item_id = cp_inventory_item_id
809: AND organization_id = cp_organization_id
810: AND ROWNUM = 1;

Line 807: SELECT 1 FROM mtl_reservations

803: AND ROWNUM = 1;
804:
805: CURSOR c_items_reserv( cp_organization_id mtl_reservations.organization_id%TYPE,
806: cp_inventory_item_id mtl_reservations. inventory_item_id%TYPE) IS
807: SELECT 1 FROM mtl_reservations
808: WHERE inventory_item_id = cp_inventory_item_id
809: AND organization_id = cp_organization_id
810: AND ROWNUM = 1;
811:

Line 829: FROM mtl_reservations mr

825: AND (lot_number = cp_lot_number or cp_lot_number is null)
826: AND (lpn_id = cp_lpn_id OR cp_lpn_id IS NULL) -- Bug 14240066
827: AND EXISTS
828: (SELECT 1
829: FROM mtl_reservations mr
830: WHERE mr.inventory_item_id = moq.inventory_item_id
831: AND mr.organization_id = moq.organization_id
832: AND ( (mr.inventory_item_id = cp_inventory_item_id )
833: OR cp_inventory_item_id IS NULL