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 788: l_tag_qty_at_standard_uom NUMBER;

784: IS
785: l_tag_id NUMBER;
786: l_tag_number VARCHAR2(40);
787: l_next_tag_number VARCHAR2(40);
788: l_tag_qty_at_standard_uom NUMBER;
789: l_outermost_lpn_id NUMBER;
790: l_lot_expiration_date Date; /* Bug8199582 */
791: CURSOR tag_number_cursor IS
792: SELECT next_tag_number

Line 808: l_item_standard_uom VARCHAR2(3);

804: l_to_number NUMBER;
805: l_errorcode NUMBER;
806: l_length NUMBER;
807: l_padded_length NUMBER;
808: l_item_standard_uom VARCHAR2(3);
809: l_employee_id NUMBER;
810:
811: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
812: BEGIN

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

871: IF (l_debug = 1) THEN
872: print_debug('Update physical inventory with next tag number: ' || l_next_tag_number);
873: END IF;
874:
875: -- Calculate the tag quantity at standard uom
876: SELECT primary_uom_code
877: INTO l_item_standard_uom
878: FROM mtl_system_items
879: WHERE inventory_item_id = p_inventory_item_id

Line 877: INTO l_item_standard_uom

873: END IF;
874:
875: -- Calculate the tag quantity at standard uom
876: SELECT primary_uom_code
877: INTO l_item_standard_uom
878: FROM mtl_system_items
879: WHERE inventory_item_id = p_inventory_item_id
880: AND organization_id = p_organization_id;
881: -- I assume that the primary_uom_code is always given for an item

Line 883: l_tag_qty_at_standard_uom := inv_convert.inv_um_convert

879: WHERE inventory_item_id = p_inventory_item_id
880: AND organization_id = p_organization_id;
881: -- I assume that the primary_uom_code is always given for an item
882: --bug 8526693 added lot no and org id parameters to invoke inv_convert to honor lot specific conversions
883: l_tag_qty_at_standard_uom := inv_convert.inv_um_convert
884: ( item_id => p_inventory_item_id,
885: lot_number => p_lot_number,
886: organization_id => p_organization_id,
887: precision => 5,

Line 890: to_unit => l_item_standard_uom,

886: organization_id => p_organization_id,
887: precision => 5,
888: from_quantity => p_tag_quantity,
889: from_unit => p_tag_uom,
890: to_unit => l_item_standard_uom,
891: from_name => NULL,
892: to_name => NULL);
893: -- Conversion will return -99999 if unsuccessful so need to check for this
894: IF (l_tag_qty_at_standard_uom = -99999) THEN

Line 894: IF (l_tag_qty_at_standard_uom = -99999) THEN

890: to_unit => l_item_standard_uom,
891: from_name => NULL,
892: to_name => NULL);
893: -- Conversion will return -99999 if unsuccessful so need to check for this
894: IF (l_tag_qty_at_standard_uom = -99999) THEN
895: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONVERSION');
896: FND_MSG_PUB.ADD;
897: RAISE FND_API.G_EXC_ERROR;
898: END IF;

Line 1001: tag_quantity_at_standard_uom,

997: adjustment_id,
998: inventory_item_id,
999: tag_quantity,
1000: tag_uom,
1001: tag_quantity_at_standard_uom,
1002: standard_uom,
1003: subinventory,
1004: locator_id,
1005: lot_number,

Line 1002: standard_uom,

998: inventory_item_id,
999: tag_quantity,
1000: tag_uom,
1001: tag_quantity_at_standard_uom,
1002: standard_uom,
1003: subinventory,
1004: locator_id,
1005: lot_number,
1006: revision,

Line 1032: l_tag_qty_at_standard_uom,

1028: p_adjustment_id,
1029: p_inventory_item_id,
1030: p_tag_quantity,
1031: p_tag_uom,
1032: l_tag_qty_at_standard_uom,
1033: l_item_standard_uom,
1034: p_subinventory,
1035: p_locator_id,
1036: p_lot_number,

Line 1033: l_item_standard_uom,

1029: p_inventory_item_id,
1030: p_tag_quantity,
1031: p_tag_uom,
1032: l_tag_qty_at_standard_uom,
1033: l_item_standard_uom,
1034: p_subinventory,
1035: p_locator_id,
1036: p_lot_number,
1037: p_revision,

Line 1079: l_tag_qty_at_standard_uom NUMBER;

1075: p_adjustment_id IN NUMBER
1076: ,p_tag_sec_quantity IN NUMBER := NULL --INVCONV, NSRIVAST, START
1077: )
1078: IS
1079: l_tag_qty_at_standard_uom NUMBER;
1080: l_outermost_lpn_id NUMBER;
1081: l_item_standard_uom VARCHAR2(3);
1082: l_return_status VARCHAR2(300);
1083: l_msg_count NUMBER;

Line 1081: l_item_standard_uom VARCHAR2(3);

1077: )
1078: IS
1079: l_tag_qty_at_standard_uom NUMBER;
1080: l_outermost_lpn_id NUMBER;
1081: l_item_standard_uom VARCHAR2(3);
1082: l_return_status VARCHAR2(300);
1083: l_msg_count NUMBER;
1084: l_msg_data VARCHAR2(300);
1085: l_lpn_list WMS_Container_PUB.LPN_Table_Type;

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

1089: BEGIN
1090: IF (l_debug = 1) THEN
1091: print_debug('***update_row***');
1092: END IF;
1093: -- Calculate the tag quantity at standard uom
1094: SELECT primary_uom_code
1095: INTO l_item_standard_uom
1096: FROM mtl_system_items
1097: WHERE inventory_item_id = p_inventory_item_id

Line 1095: INTO l_item_standard_uom

1091: print_debug('***update_row***');
1092: END IF;
1093: -- Calculate the tag quantity at standard uom
1094: SELECT primary_uom_code
1095: INTO l_item_standard_uom
1096: FROM mtl_system_items
1097: WHERE inventory_item_id = p_inventory_item_id
1098: AND organization_id = p_organization_id;
1099: -- I assume that the primary_uom_code is always given for an item

Line 1101: l_tag_qty_at_standard_uom := inv_convert.inv_um_convert

1097: WHERE inventory_item_id = p_inventory_item_id
1098: AND organization_id = p_organization_id;
1099: -- I assume that the primary_uom_code is always given for an item
1100: --bug 8526693 added lot no and org id parameters to invoke inv_convert to honor lot specific conversions
1101: l_tag_qty_at_standard_uom := inv_convert.inv_um_convert
1102: ( item_id => p_inventory_item_id,
1103: lot_number => p_lot_number,
1104: organization_id => p_organization_id,
1105: precision => 5,

Line 1108: to_unit => l_item_standard_uom,

1104: organization_id => p_organization_id,
1105: precision => 5,
1106: from_quantity => p_tag_quantity,
1107: from_unit => p_tag_uom,
1108: to_unit => l_item_standard_uom,
1109: from_name => NULL,
1110: to_name => NULL);
1111: -- Conversion will return -99999 if unsuccessful so need to check for this
1112: IF (l_tag_qty_at_standard_uom = -99999) THEN

Line 1112: IF (l_tag_qty_at_standard_uom = -99999) THEN

1108: to_unit => l_item_standard_uom,
1109: from_name => NULL,
1110: to_name => NULL);
1111: -- Conversion will return -99999 if unsuccessful so need to check for this
1112: IF (l_tag_qty_at_standard_uom = -99999) THEN
1113: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONVERSION');
1114: FND_MSG_PUB.ADD;
1115: RAISE FND_API.G_EXC_ERROR;
1116: END IF;

Line 1195: tag_quantity_at_standard_uom = l_tag_qty_at_standard_uom,

1191: adjustment_id = p_adjustment_id,
1192: inventory_item_id = p_inventory_item_id,
1193: tag_quantity = p_tag_quantity,
1194: tag_uom = p_tag_uom,
1195: tag_quantity_at_standard_uom = l_tag_qty_at_standard_uom,
1196: standard_uom = l_item_standard_uom,
1197: subinventory = p_subinventory,
1198: locator_id = p_locator_id,
1199: lot_number = p_lot_number,

Line 1196: standard_uom = l_item_standard_uom,

1192: inventory_item_id = p_inventory_item_id,
1193: tag_quantity = p_tag_quantity,
1194: tag_uom = p_tag_uom,
1195: tag_quantity_at_standard_uom = l_tag_qty_at_standard_uom,
1196: standard_uom = l_item_standard_uom,
1197: subinventory = p_subinventory,
1198: locator_id = p_locator_id,
1199: lot_number = p_lot_number,
1200: revision = p_revision,

Line 1234: l_standard_uom_code VARCHAR2(3);

1230: l_lpn_id NUMBER;
1231: l_subinventory VARCHAR2(10);
1232: l_locator_id NUMBER;
1233: l_adjustment_quantity NUMBER;
1234: l_standard_uom_code VARCHAR2(3);
1235: l_label_status VARCHAR2(300) := NULL;
1236: l_return_status VARCHAR2(3000);
1237: l_msg_count NUMBER;
1238: l_msg_data VARCHAR2(3000);

Line 1247: secondary uom. Hence no need of tag_secondary_at_standard_uom */

1243: print_debug('***update_adjustment***');
1244: END IF;
1245:
1246: /* Fix for Bug#7591655. Added tag_secondary_quantity in following select. Secondary qty is always at
1247: secondary uom. Hence no need of tag_secondary_at_standard_uom */
1248:
1249: SELECT NVL(SUM(tag_quantity_at_standard_uom),0),
1250: NVL(SUM(tag_secondary_quantity),0)
1251: INTO l_adj_count_quantity,

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

1245:
1246: /* Fix for Bug#7591655. Added tag_secondary_quantity in following select. Secondary qty is always at
1247: secondary uom. Hence no need of tag_secondary_at_standard_uom */
1248:
1249: SELECT NVL(SUM(tag_quantity_at_standard_uom),0),
1250: NVL(SUM(tag_secondary_quantity),0)
1251: INTO l_adj_count_quantity,
1252: l_adj2_count_quantity
1253: FROM mtl_physical_inventory_tags

Line 1296: INTO l_standard_uom_code

1292: IF (l_debug = 1) THEN
1293: print_debug('Get the primary UOM code: ' || 'Item ID: ' || l_inventory_item_id || ': ' || 'Org ID: ' || p_organization_id);
1294: END IF;
1295: SELECT primary_uom_code
1296: INTO l_standard_uom_code
1297: FROM mtl_system_items
1298: WHERE inventory_item_id = l_inventory_item_id
1299: AND organization_id = p_organization_id;
1300:

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

1317: print_debug('p_lpn_id: -------------> ' || l_lpn_id);
1318: print_debug('p_subinventory_code: --> ' || l_subinventory);
1319: print_debug('p_locator_id: ---------> ' || l_locator_id);
1320: print_debug('p_quantity: -----------> ' || l_adjustment_quantity);
1321: print_debug('p_uom: ----------------> ' || l_standard_uom_code);
1322: print_debug('p_no_of_copies: -------> ' || 1);
1323: END IF;
1324:
1325: -- Bug# 2301732

Line 1347: p_uom => l_standard_uom_code ,

1343: p_lpn_id => l_lpn_id ,
1344: p_subinventory_code => l_subinventory ,
1345: p_locator_id => l_locator_id ,
1346: p_quantity => l_adjustment_quantity ,
1347: p_uom => l_standard_uom_code ,
1348: p_no_of_copies => 1
1349: );
1350: EXCEPTION
1351: WHEN OTHERS THEN

Line 2570: , tag_quantity_at_standard_uom = inv_convert.inv_um_convert

2566: UPDATE mtl_physical_inventory_tags
2567: set locator_id = nvl(i.to_locator, l_prev_loctor)
2568: , subinventory = nvl(i.xfr_subinventory_name,l_prev_subinv)
2569: , tag_quantity = i.count_quantity --bug 14778466
2570: , tag_quantity_at_standard_uom = inv_convert.inv_um_convert
2571: ( item_id => inventory_item_id,
2572: lot_number => lot_number,
2573: organization_id => organization_id,
2574: precision => 5,