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_PHY_INV_LOVS dependencies on STANDARD

Line 679: l_tag_qty_at_standard_uom NUMBER;

675: IS
676: l_tag_id NUMBER;
677: l_tag_number VARCHAR2(40);
678: l_next_tag_number VARCHAR2(40);
679: l_tag_qty_at_standard_uom NUMBER;
680: l_outermost_lpn_id NUMBER;
681: CURSOR tag_number_cursor IS
682: SELECT next_tag_number
683: FROM mtl_physical_inventories

Line 698: l_item_standard_uom VARCHAR2(3);

694: l_to_number NUMBER;
695: l_errorcode NUMBER;
696: l_length NUMBER;
697: l_padded_length NUMBER;
698: l_item_standard_uom VARCHAR2(3);
699: l_employee_id NUMBER;
700:
701: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
702: BEGIN

Line 765: -- Calculate the tag quantity at standard uom

761: IF (l_debug = 1) THEN
762: print_debug('Update physical inventory with next tag number: ' || l_next_tag_number);
763: END IF;
764:
765: -- Calculate the tag quantity at standard uom
766: SELECT primary_uom_code
767: INTO l_item_standard_uom
768: FROM mtl_system_items
769: WHERE inventory_item_id = p_inventory_item_id

Line 767: INTO l_item_standard_uom

763: END IF;
764:
765: -- Calculate the tag quantity at standard uom
766: SELECT primary_uom_code
767: INTO l_item_standard_uom
768: FROM mtl_system_items
769: WHERE inventory_item_id = p_inventory_item_id
770: AND organization_id = p_organization_id;
771: -- I assume that the primary_uom_code is always given for an item

Line 772: l_tag_qty_at_standard_uom := inv_convert.inv_um_convert

768: FROM mtl_system_items
769: WHERE inventory_item_id = p_inventory_item_id
770: AND organization_id = p_organization_id;
771: -- I assume that the primary_uom_code is always given for an item
772: l_tag_qty_at_standard_uom := inv_convert.inv_um_convert
773: ( item_id => p_inventory_item_id,
774: precision => 5,
775: from_quantity => p_tag_quantity,
776: from_unit => p_tag_uom,

Line 777: to_unit => l_item_standard_uom,

773: ( item_id => p_inventory_item_id,
774: precision => 5,
775: from_quantity => p_tag_quantity,
776: from_unit => p_tag_uom,
777: to_unit => l_item_standard_uom,
778: from_name => NULL,
779: to_name => NULL);
780: -- Conversion will return -99999 if unsuccessful so need to check for this
781: IF (l_tag_qty_at_standard_uom = -99999) THEN

Line 781: IF (l_tag_qty_at_standard_uom = -99999) THEN

777: to_unit => l_item_standard_uom,
778: from_name => NULL,
779: to_name => NULL);
780: -- Conversion will return -99999 if unsuccessful so need to check for this
781: IF (l_tag_qty_at_standard_uom = -99999) THEN
782: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONVERSION');
783: FND_MSG_PUB.ADD;
784: RAISE FND_API.G_EXC_ERROR;
785: END IF;

Line 857: tag_quantity_at_standard_uom,

853: adjustment_id,
854: inventory_item_id,
855: tag_quantity,
856: tag_uom,
857: tag_quantity_at_standard_uom,
858: standard_uom,
859: subinventory,
860: locator_id,
861: lot_number,

Line 858: standard_uom,

854: inventory_item_id,
855: tag_quantity,
856: tag_uom,
857: tag_quantity_at_standard_uom,
858: standard_uom,
859: subinventory,
860: locator_id,
861: lot_number,
862: revision,

Line 887: l_tag_qty_at_standard_uom,

883: p_adjustment_id,
884: p_inventory_item_id,
885: p_tag_quantity,
886: p_tag_uom,
887: l_tag_qty_at_standard_uom,
888: l_item_standard_uom,
889: p_subinventory,
890: p_locator_id,
891: p_lot_number,

Line 888: l_item_standard_uom,

884: p_inventory_item_id,
885: p_tag_quantity,
886: p_tag_uom,
887: l_tag_qty_at_standard_uom,
888: l_item_standard_uom,
889: p_subinventory,
890: p_locator_id,
891: p_lot_number,
892: p_revision,

Line 933: l_tag_qty_at_standard_uom NUMBER;

929: p_adjustment_id IN NUMBER
930: ,p_tag_sec_quantity IN NUMBER := NULL --INVCONV, NSRIVAST, START
931: )
932: IS
933: l_tag_qty_at_standard_uom NUMBER;
934: l_outermost_lpn_id NUMBER;
935: l_item_standard_uom VARCHAR2(3);
936: l_return_status VARCHAR2(300);
937: l_msg_count NUMBER;

Line 935: l_item_standard_uom VARCHAR2(3);

931: )
932: IS
933: l_tag_qty_at_standard_uom NUMBER;
934: l_outermost_lpn_id NUMBER;
935: l_item_standard_uom VARCHAR2(3);
936: l_return_status VARCHAR2(300);
937: l_msg_count NUMBER;
938: l_msg_data VARCHAR2(300);
939: l_lpn_list WMS_Container_PUB.LPN_Table_Type;

Line 947: -- Calculate the tag quantity at standard uom

943: BEGIN
944: IF (l_debug = 1) THEN
945: print_debug('***update_row***');
946: END IF;
947: -- Calculate the tag quantity at standard uom
948: SELECT primary_uom_code
949: INTO l_item_standard_uom
950: FROM mtl_system_items
951: WHERE inventory_item_id = p_inventory_item_id

Line 949: INTO l_item_standard_uom

945: print_debug('***update_row***');
946: END IF;
947: -- Calculate the tag quantity at standard uom
948: SELECT primary_uom_code
949: INTO l_item_standard_uom
950: FROM mtl_system_items
951: WHERE inventory_item_id = p_inventory_item_id
952: AND organization_id = p_organization_id;
953: -- I assume that the primary_uom_code is always given for an item

Line 954: l_tag_qty_at_standard_uom := inv_convert.inv_um_convert

950: FROM mtl_system_items
951: WHERE inventory_item_id = p_inventory_item_id
952: AND organization_id = p_organization_id;
953: -- I assume that the primary_uom_code is always given for an item
954: l_tag_qty_at_standard_uom := inv_convert.inv_um_convert
955: ( item_id => p_inventory_item_id,
956: precision => 5,
957: from_quantity => p_tag_quantity,
958: from_unit => p_tag_uom,

Line 959: to_unit => l_item_standard_uom,

955: ( item_id => p_inventory_item_id,
956: precision => 5,
957: from_quantity => p_tag_quantity,
958: from_unit => p_tag_uom,
959: to_unit => l_item_standard_uom,
960: from_name => NULL,
961: to_name => NULL);
962: -- Conversion will return -99999 if unsuccessful so need to check for this
963: IF (l_tag_qty_at_standard_uom = -99999) THEN

Line 963: IF (l_tag_qty_at_standard_uom = -99999) THEN

959: to_unit => l_item_standard_uom,
960: from_name => NULL,
961: to_name => NULL);
962: -- Conversion will return -99999 if unsuccessful so need to check for this
963: IF (l_tag_qty_at_standard_uom = -99999) THEN
964: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONVERSION');
965: FND_MSG_PUB.ADD;
966: RAISE FND_API.G_EXC_ERROR;
967: END IF;

Line 1033: tag_quantity_at_standard_uom = l_tag_qty_at_standard_uom,

1029: adjustment_id = p_adjustment_id,
1030: inventory_item_id = p_inventory_item_id,
1031: tag_quantity = p_tag_quantity,
1032: tag_uom = p_tag_uom,
1033: tag_quantity_at_standard_uom = l_tag_qty_at_standard_uom,
1034: standard_uom = l_item_standard_uom,
1035: subinventory = p_subinventory,
1036: locator_id = p_locator_id,
1037: lot_number = p_lot_number,

Line 1034: standard_uom = l_item_standard_uom,

1030: inventory_item_id = p_inventory_item_id,
1031: tag_quantity = p_tag_quantity,
1032: tag_uom = p_tag_uom,
1033: tag_quantity_at_standard_uom = l_tag_qty_at_standard_uom,
1034: standard_uom = l_item_standard_uom,
1035: subinventory = p_subinventory,
1036: locator_id = p_locator_id,
1037: lot_number = p_lot_number,
1038: revision = p_revision,

Line 1071: l_standard_uom_code VARCHAR2(3);

1067: l_lpn_id NUMBER;
1068: l_subinventory VARCHAR2(10);
1069: l_locator_id NUMBER;
1070: l_adjustment_quantity NUMBER;
1071: l_standard_uom_code VARCHAR2(3);
1072: l_label_status VARCHAR2(300) := NULL;
1073: l_return_status VARCHAR2(3000);
1074: l_msg_count NUMBER;
1075: l_msg_data VARCHAR2(3000);

Line 1082: SELECT NVL(SUM(tag_quantity_at_standard_uom),0)

1078: BEGIN
1079: IF (l_debug = 1) THEN
1080: print_debug('***update_adjustment***');
1081: END IF;
1082: SELECT NVL(SUM(tag_quantity_at_standard_uom),0)
1083: INTO l_adj_count_quantity
1084: FROM mtl_physical_inventory_tags
1085: WHERE adjustment_id = p_adjustment_id
1086: AND organization_id = p_organization_id

Line 1123: INTO l_standard_uom_code

1119: IF (l_debug = 1) THEN
1120: print_debug('Get the primary UOM code: ' || 'Item ID: ' || l_inventory_item_id || ': ' || 'Org ID: ' || p_organization_id);
1121: END IF;
1122: SELECT primary_uom_code
1123: INTO l_standard_uom_code
1124: FROM mtl_system_items
1125: WHERE inventory_item_id = l_inventory_item_id
1126: AND organization_id = p_organization_id;
1127:

Line 1148: print_debug('p_uom: ----------------> ' || l_standard_uom_code);

1144: print_debug('p_lpn_id: -------------> ' || l_lpn_id);
1145: print_debug('p_subinventory_code: --> ' || l_subinventory);
1146: print_debug('p_locator_id: ---------> ' || l_locator_id);
1147: print_debug('p_quantity: -----------> ' || l_adjustment_quantity);
1148: print_debug('p_uom: ----------------> ' || l_standard_uom_code);
1149: print_debug('p_no_of_copies: -------> ' || 1);
1150: END IF;
1151:
1152: -- Bug# 2301732

Line 1174: p_uom => l_standard_uom_code ,

1170: p_lpn_id => l_lpn_id ,
1171: p_subinventory_code => l_subinventory ,
1172: p_locator_id => l_locator_id ,
1173: p_quantity => l_adjustment_quantity ,
1174: p_uom => l_standard_uom_code ,
1175: p_no_of_copies => 1
1176: );
1177: EXCEPTION
1178: WHEN OTHERS THEN