eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MATERIAL_STATUS_PKG dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 74: from mtl_onhand_quantities_detail moqd, mtl_parameters mp

70: select 1
71: into count_assigned
72: from dual
73: where exists (select 1
74: from mtl_onhand_quantities_detail moqd, mtl_parameters mp
75: where moqd.organization_id = mp.organization_id
76: and mp.default_status_id is not null
77: and nvl(moqd.status_id, -9999) = p_status_id
78: and rownum = 1); -- Do we need to add rownum as the query is inside 'exists'.

Line 577: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,

573: /* bug 11806801 */
574: FUNCTION validate_mtstatus2(
575: p_old_status_id mtl_material_statuses.status_id%TYPE,
576: p_new_status_id mtl_material_statuses.status_id%TYPE ,
577: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
578: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
579: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
580: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
581: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE

Line 578: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,

574: FUNCTION validate_mtstatus2(
575: p_old_status_id mtl_material_statuses.status_id%TYPE,
576: p_new_status_id mtl_material_statuses.status_id%TYPE ,
577: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
578: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
579: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
580: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
581: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE
582: )RETURN CHAR AS

Line 580: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,

576: p_new_status_id mtl_material_statuses.status_id%TYPE ,
577: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
578: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
579: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
580: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
581: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE
582: )RETURN CHAR AS
583:
584: l_return_status BOOLEAN;

Line 581: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE

577: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
578: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
579: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
580: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
581: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE
582: )RETURN CHAR AS
583:
584: l_return_status BOOLEAN;
585:

Line 611: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,

607:
608: FUNCTION validate_mtstatus(
609: p_old_status_id mtl_material_statuses.status_id%TYPE,
610: p_new_status_id mtl_material_statuses.status_id%TYPE ,
611: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
612: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
613: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
614: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE
615: )RETURN BOOLEAN AS

Line 612: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,

608: FUNCTION validate_mtstatus(
609: p_old_status_id mtl_material_statuses.status_id%TYPE,
610: p_new_status_id mtl_material_statuses.status_id%TYPE ,
611: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
612: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
613: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
614: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE
615: )RETURN BOOLEAN AS
616:

Line 614: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE

610: p_new_status_id mtl_material_statuses.status_id%TYPE ,
611: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
612: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
613: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
614: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE
615: )RETURN BOOLEAN AS
616:
617: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE := NULL;
618: l_return_status BOOLEAN;

Line 617: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE := NULL;

613: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
614: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE
615: )RETURN BOOLEAN AS
616:
617: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE := NULL;
618: l_return_status BOOLEAN;
619:
620: BEGIN
621:

Line 651: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,

647: /* Bug 6837479 */
648: FUNCTION validate_mtstatus(
649: p_old_status_id mtl_material_statuses.status_id%TYPE,
650: p_new_status_id mtl_material_statuses.status_id%TYPE ,
651: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
652: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
653: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
654: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
655: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE,

Line 652: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,

648: FUNCTION validate_mtstatus(
649: p_old_status_id mtl_material_statuses.status_id%TYPE,
650: p_new_status_id mtl_material_statuses.status_id%TYPE ,
651: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
652: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
653: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
654: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
655: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE,
656: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066

Line 654: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,

650: p_new_status_id mtl_material_statuses.status_id%TYPE ,
651: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
652: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
653: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
654: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
655: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE,
656: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
657: )RETURN BOOLEAN AS
658:

Line 655: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE,

651: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
652: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
653: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
654: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
655: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE,
656: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
657: )RETURN BOOLEAN AS
658:
659: l_return_status BOOLEAN;

Line 656: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066

652: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
653: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
654: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
655: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE,
656: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
657: )RETURN BOOLEAN AS
658:
659: l_return_status BOOLEAN;
660: l_dummy_param NUMBER := 1;

Line 718: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,

714: --INVCONV kkillams
715: FUNCTION validate_mtstatus(
716: p_old_status_id mtl_material_statuses.status_id%TYPE,
717: p_new_status_id mtl_material_statuses.status_id%TYPE ,
718: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
719: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
720: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
721: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
722: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE, /* bug 6837479 */

Line 719: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,

715: FUNCTION validate_mtstatus(
716: p_old_status_id mtl_material_statuses.status_id%TYPE,
717: p_new_status_id mtl_material_statuses.status_id%TYPE ,
718: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
719: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
720: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
721: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
722: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE, /* bug 6837479 */
723: p_dummy_param NUMBER,

Line 721: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,

717: p_new_status_id mtl_material_statuses.status_id%TYPE ,
718: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
719: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
720: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
721: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
722: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE, /* bug 6837479 */
723: p_dummy_param NUMBER,
724: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
725: )RETURN BOOLEAN AS

Line 722: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE, /* bug 6837479 */

718: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
719: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
720: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
721: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
722: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE, /* bug 6837479 */
723: p_dummy_param NUMBER,
724: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
725: )RETURN BOOLEAN AS
726: CURSOR cur_mt_status (cp_old_status_id mtl_material_statuses.status_code%TYPE,

Line 724: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066

720: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
721: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
722: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE, /* bug 6837479 */
723: p_dummy_param NUMBER,
724: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
725: )RETURN BOOLEAN AS
726: CURSOR cur_mt_status (cp_old_status_id mtl_material_statuses.status_code%TYPE,
727: cp_new_status_id mtl_material_statuses.status_code%TYPE) IS
728: SELECT 1 FROM mtl_material_statuses mts1,

Line 736: CURSOR c_subinv_items(cp_organization_id mtl_onhand_quantities_detail.organization_id%TYPE,

732: AND mts1.reservable_type = 1
733: AND mts2.status_id = cp_new_status_id
734: AND mts2.reservable_type <> mts1.reservable_type;
735:
736: CURSOR c_subinv_items(cp_organization_id mtl_onhand_quantities_detail.organization_id%TYPE,
737: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
738: cp_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE) IS
739: SELECT 1 FROM mtl_onhand_quantities_detail moq
740: WHERE organization_id = cp_organization_id

Line 737: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,

733: AND mts2.status_id = cp_new_status_id
734: AND mts2.reservable_type <> mts1.reservable_type;
735:
736: CURSOR c_subinv_items(cp_organization_id mtl_onhand_quantities_detail.organization_id%TYPE,
737: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
738: cp_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE) IS
739: SELECT 1 FROM mtl_onhand_quantities_detail moq
740: WHERE organization_id = cp_organization_id
741: AND subinventory_code = cp_subinventory_code

Line 738: cp_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE) IS

734: AND mts2.reservable_type <> mts1.reservable_type;
735:
736: CURSOR c_subinv_items(cp_organization_id mtl_onhand_quantities_detail.organization_id%TYPE,
737: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
738: cp_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE) IS
739: SELECT 1 FROM mtl_onhand_quantities_detail moq
740: WHERE organization_id = cp_organization_id
741: AND subinventory_code = cp_subinventory_code
742: AND EXISTS

Line 739: SELECT 1 FROM mtl_onhand_quantities_detail moq

735:
736: CURSOR c_subinv_items(cp_organization_id mtl_onhand_quantities_detail.organization_id%TYPE,
737: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
738: cp_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE) IS
739: SELECT 1 FROM mtl_onhand_quantities_detail moq
740: WHERE organization_id = cp_organization_id
741: AND subinventory_code = cp_subinventory_code
742: AND EXISTS
743: (SELECT 1

Line 758: CURSOR c_locator_items(cp_organization_id mtl_onhand_quantities_detail.organization_id%TYPE,

754: )
755: )
756: AND ROWNUM = 1;
757:
758: CURSOR c_locator_items(cp_organization_id mtl_onhand_quantities_detail.organization_id%TYPE,
759: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
760: cp_locator_id mtl_onhand_quantities_detail.locator_id%TYPE) IS
761: SELECT 1 FROM mtl_onhand_quantities_detail moq
762: WHERE organization_id = cp_organization_id

Line 759: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,

755: )
756: AND ROWNUM = 1;
757:
758: CURSOR c_locator_items(cp_organization_id mtl_onhand_quantities_detail.organization_id%TYPE,
759: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
760: cp_locator_id mtl_onhand_quantities_detail.locator_id%TYPE) IS
761: SELECT 1 FROM mtl_onhand_quantities_detail moq
762: WHERE organization_id = cp_organization_id
763: AND locator_id = cp_locator_id

Line 760: cp_locator_id mtl_onhand_quantities_detail.locator_id%TYPE) IS

756: AND ROWNUM = 1;
757:
758: CURSOR c_locator_items(cp_organization_id mtl_onhand_quantities_detail.organization_id%TYPE,
759: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
760: cp_locator_id mtl_onhand_quantities_detail.locator_id%TYPE) IS
761: SELECT 1 FROM mtl_onhand_quantities_detail moq
762: WHERE organization_id = cp_organization_id
763: AND locator_id = cp_locator_id
764: AND EXISTS

Line 761: SELECT 1 FROM mtl_onhand_quantities_detail moq

757:
758: CURSOR c_locator_items(cp_organization_id mtl_onhand_quantities_detail.organization_id%TYPE,
759: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
760: cp_locator_id mtl_onhand_quantities_detail.locator_id%TYPE) IS
761: SELECT 1 FROM mtl_onhand_quantities_detail moq
762: WHERE organization_id = cp_organization_id
763: AND locator_id = cp_locator_id
764: AND EXISTS
765: (SELECT 1

Line 786: cp_lot_number mtl_onhand_quantities_detail.lot_number%TYPE) IS

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)
790: AND lot_number = cp_lot_number

Line 787: SELECT 1 FROM mtl_onhand_quantities_detail moq

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)
790: AND lot_number = cp_lot_number
791: AND EXISTS

Line 813: CURSOR c_onhand_items( cp_organization_id mtl_onhand_quantities_detail.organization_id%TYPE,

809: AND organization_id = cp_organization_id
810: AND ROWNUM = 1;
811:
812: /*Added new cursor for Bug 12430080 */
813: CURSOR c_onhand_items( cp_organization_id mtl_onhand_quantities_detail.organization_id%TYPE,
814: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
815: cp_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
816: cp_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
817: cp_lot_number mtl_onhand_quantities_detail.lot_number%TYPE,

Line 814: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,

810: AND ROWNUM = 1;
811:
812: /*Added new cursor for Bug 12430080 */
813: CURSOR c_onhand_items( cp_organization_id mtl_onhand_quantities_detail.organization_id%TYPE,
814: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
815: cp_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
816: cp_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
817: cp_lot_number mtl_onhand_quantities_detail.lot_number%TYPE,
818: cp_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE) IS -- Bug 14240066

Line 815: cp_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,

811:
812: /*Added new cursor for Bug 12430080 */
813: CURSOR c_onhand_items( cp_organization_id mtl_onhand_quantities_detail.organization_id%TYPE,
814: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
815: cp_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
816: cp_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
817: cp_lot_number mtl_onhand_quantities_detail.lot_number%TYPE,
818: cp_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE) IS -- Bug 14240066
819:

Line 816: cp_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,

812: /*Added new cursor for Bug 12430080 */
813: CURSOR c_onhand_items( cp_organization_id mtl_onhand_quantities_detail.organization_id%TYPE,
814: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
815: cp_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
816: cp_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
817: cp_lot_number mtl_onhand_quantities_detail.lot_number%TYPE,
818: cp_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE) IS -- Bug 14240066
819:
820: SELECT 1 FROM mtl_onhand_quantities_detail moq

Line 817: cp_lot_number mtl_onhand_quantities_detail.lot_number%TYPE,

813: CURSOR c_onhand_items( cp_organization_id mtl_onhand_quantities_detail.organization_id%TYPE,
814: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
815: cp_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
816: cp_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
817: cp_lot_number mtl_onhand_quantities_detail.lot_number%TYPE,
818: cp_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE) IS -- Bug 14240066
819:
820: SELECT 1 FROM mtl_onhand_quantities_detail moq
821: WHERE organization_id = cp_organization_id

Line 818: cp_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE) IS -- Bug 14240066

814: cp_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
815: cp_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
816: cp_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
817: cp_lot_number mtl_onhand_quantities_detail.lot_number%TYPE,
818: cp_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE) IS -- Bug 14240066
819:
820: SELECT 1 FROM mtl_onhand_quantities_detail moq
821: WHERE organization_id = cp_organization_id
822: AND (inventory_item_id = cp_inventory_item_id OR cp_inventory_item_id IS NULL)

Line 820: SELECT 1 FROM mtl_onhand_quantities_detail moq

816: cp_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
817: cp_lot_number mtl_onhand_quantities_detail.lot_number%TYPE,
818: cp_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE) IS -- Bug 14240066
819:
820: SELECT 1 FROM mtl_onhand_quantities_detail moq
821: WHERE organization_id = cp_organization_id
822: AND (inventory_item_id = cp_inventory_item_id OR cp_inventory_item_id IS NULL)
823: AND (subinventory_code = cp_subinventory_code OR cp_subinventory_code IS NULL)
824: AND (locator_id = cp_locator_id OR cp_locator_id IS NULL)