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_TRANSFER_ORDER_PVT dependencies on INV_GLOBALS

Line 74: inv_globals.g_max_line_num := NVL(inv_globals.g_max_line_num, 0) + 1;

70: END;
71:
72: PROCEDURE increment_max_line_number IS
73: BEGIN
74: inv_globals.g_max_line_num := NVL(inv_globals.g_max_line_num, 0) + 1;
75: --debug('Line Num:'||to_char(Inv_Globals.g_max_line_num));
76: END increment_max_line_number;
77:
78: PROCEDURE reset_max_line_number IS

Line 75: --debug('Line Num:'||to_char(Inv_Globals.g_max_line_num));

71:
72: PROCEDURE increment_max_line_number IS
73: BEGIN
74: inv_globals.g_max_line_num := NVL(inv_globals.g_max_line_num, 0) + 1;
75: --debug('Line Num:'||to_char(Inv_Globals.g_max_line_num));
76: END increment_max_line_number;
77:
78: PROCEDURE reset_max_line_number IS
79: BEGIN

Line 80: inv_globals.g_max_line_num := NULL;

76: END increment_max_line_number;
77:
78: PROCEDURE reset_max_line_number IS
79: BEGIN
80: inv_globals.g_max_line_num := NULL;
81: --debug('Line Num:'||to_char(Inv_Globals.g_max_line_num));
82: END reset_max_line_number;
83:
84: FUNCTION get_next_header_id(p_organization_id NUMBER := NULL)

Line 81: --debug('Line Num:'||to_char(Inv_Globals.g_max_line_num));

77:
78: PROCEDURE reset_max_line_number IS
79: BEGIN
80: inv_globals.g_max_line_num := NULL;
81: --debug('Line Num:'||to_char(Inv_Globals.g_max_line_num));
82: END reset_max_line_number;
83:
84: FUNCTION get_next_header_id(p_organization_id NUMBER := NULL)
85: RETURN NUMBER IS

Line 948: , p_control_rec IN inv_globals.control_rec_type

944: END update_troldt;
945:
946: PROCEDURE trohdr(
947: p_validation_level IN NUMBER
948: , p_control_rec IN inv_globals.control_rec_type
949: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
950: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type
951: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
952: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type

Line 956: l_control_rec inv_globals.control_rec_type;

952: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
953: , x_old_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
954: ) IS
955: l_return_status VARCHAR2(1);
956: l_control_rec inv_globals.control_rec_type;
957: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
958: --Bug# 4554438, this var will be used to avoid NOCOPY issues
959: l_tmp_trohdr_rec inv_move_order_pub.trohdr_rec_type;
960: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;

Line 967: l_control_rec := inv_globals.init_control_rec(p_operation => l_trohdr_rec.operation, p_control_rec => p_control_rec);

963: BEGIN
964:
965:
966: -- Load API control record
967: l_control_rec := inv_globals.init_control_rec(p_operation => l_trohdr_rec.operation, p_control_rec => p_control_rec);
968: -- Set record return status.
969: l_trohdr_rec.return_status := fnd_api.g_ret_sts_success;
970:
971: -- Prepare record.

Line 972: IF l_trohdr_rec.operation = inv_globals.g_opr_create THEN

968: -- Set record return status.
969: l_trohdr_rec.return_status := fnd_api.g_ret_sts_success;
970:
971: -- Prepare record.
972: IF l_trohdr_rec.operation = inv_globals.g_opr_create THEN
973: l_trohdr_rec.db_flag := fnd_api.g_false;
974: -- Set missing old record elements to NULL.
975: l_old_trohdr_rec := inv_trohdr_util.convert_miss_to_null(l_old_trohdr_rec);
976: ELSIF l_trohdr_rec.operation = inv_globals.g_opr_update

Line 976: ELSIF l_trohdr_rec.operation = inv_globals.g_opr_update

972: IF l_trohdr_rec.operation = inv_globals.g_opr_create THEN
973: l_trohdr_rec.db_flag := fnd_api.g_false;
974: -- Set missing old record elements to NULL.
975: l_old_trohdr_rec := inv_trohdr_util.convert_miss_to_null(l_old_trohdr_rec);
976: ELSIF l_trohdr_rec.operation = inv_globals.g_opr_update
977: OR l_trohdr_rec.operation = inv_globals.g_opr_delete THEN
978: l_trohdr_rec.db_flag := fnd_api.g_true;
979:
980: -- Query Old if missing

Line 977: OR l_trohdr_rec.operation = inv_globals.g_opr_delete THEN

973: l_trohdr_rec.db_flag := fnd_api.g_false;
974: -- Set missing old record elements to NULL.
975: l_old_trohdr_rec := inv_trohdr_util.convert_miss_to_null(l_old_trohdr_rec);
976: ELSIF l_trohdr_rec.operation = inv_globals.g_opr_update
977: OR l_trohdr_rec.operation = inv_globals.g_opr_delete THEN
978: l_trohdr_rec.db_flag := fnd_api.g_true;
979:
980: -- Query Old if missing
981: IF l_old_trohdr_rec.header_id = fnd_api.g_miss_num THEN

Line 995: IF (l_trohdr_rec.operation = inv_globals.g_opr_update

991:
992: --Bug 4756455 (11.5.10 bug 4755172 )
993: --Reverted change of Bug 4329971 here and removed the code
994:
995: IF (l_trohdr_rec.operation = inv_globals.g_opr_update
996: OR l_trohdr_rec.operation = inv_globals.g_opr_create
997: OR l_trohdr_rec.operation = inv_globals.g_opr_delete)
998: THEN
999: -- Attribute level validation.

Line 996: OR l_trohdr_rec.operation = inv_globals.g_opr_create

992: --Bug 4756455 (11.5.10 bug 4755172 )
993: --Reverted change of Bug 4329971 here and removed the code
994:
995: IF (l_trohdr_rec.operation = inv_globals.g_opr_update
996: OR l_trohdr_rec.operation = inv_globals.g_opr_create
997: OR l_trohdr_rec.operation = inv_globals.g_opr_delete)
998: THEN
999: -- Attribute level validation.
1000: IF l_control_rec.default_attributes

Line 997: OR l_trohdr_rec.operation = inv_globals.g_opr_delete)

993: --Reverted change of Bug 4329971 here and removed the code
994:
995: IF (l_trohdr_rec.operation = inv_globals.g_opr_update
996: OR l_trohdr_rec.operation = inv_globals.g_opr_create
997: OR l_trohdr_rec.operation = inv_globals.g_opr_delete)
998: THEN
999: -- Attribute level validation.
1000: IF l_control_rec.default_attributes
1001: OR l_control_rec.change_attributes THEN

Line 1040: IF l_trohdr_rec.operation = inv_globals.g_opr_delete THEN

1036: END IF;
1037:
1038: -- Entity level validation.
1039: IF l_control_rec.validate_entity THEN
1040: IF l_trohdr_rec.operation = inv_globals.g_opr_delete THEN
1041: inv_validate_trohdr.entity_delete(x_return_status => l_return_status, p_trohdr_rec => l_trohdr_rec);
1042: ELSE
1043: inv_validate_trohdr.entity(x_return_status => l_return_status, p_trohdr_rec => l_trohdr_rec, p_old_trohdr_rec => l_old_trohdr_rec);
1044: END IF;

Line 1055: IF l_trohdr_rec.operation = inv_globals.g_opr_delete THEN

1051: END IF;
1052:
1053: -- Step 4. Write to DB
1054: IF l_control_rec.write_to_db THEN
1055: IF l_trohdr_rec.operation = inv_globals.g_opr_delete THEN
1056: inv_trohdr_util.delete_row(p_header_id => l_trohdr_rec.header_id);
1057: ELSE
1058: -- Get Who Information
1059: l_trohdr_rec.last_update_date := SYSDATE;

Line 1063: IF l_trohdr_rec.operation = inv_globals.g_opr_update THEN

1059: l_trohdr_rec.last_update_date := SYSDATE;
1060: l_trohdr_rec.last_updated_by := fnd_global.user_id;
1061: l_trohdr_rec.last_update_login := fnd_global.login_id;
1062:
1063: IF l_trohdr_rec.operation = inv_globals.g_opr_update THEN
1064: inv_trohdr_util.update_row(l_trohdr_rec);
1065: ELSIF l_trohdr_rec.operation = inv_globals.g_opr_create THEN
1066: l_trohdr_rec.creation_date := SYSDATE;
1067: l_trohdr_rec.created_by := fnd_global.user_id;

Line 1065: ELSIF l_trohdr_rec.operation = inv_globals.g_opr_create THEN

1061: l_trohdr_rec.last_update_login := fnd_global.login_id;
1062:
1063: IF l_trohdr_rec.operation = inv_globals.g_opr_update THEN
1064: inv_trohdr_util.update_row(l_trohdr_rec);
1065: ELSIF l_trohdr_rec.operation = inv_globals.g_opr_create THEN
1066: l_trohdr_rec.creation_date := SYSDATE;
1067: l_trohdr_rec.created_by := fnd_global.user_id;
1068: inv_trohdr_util.insert_row(l_trohdr_rec);
1069: END IF;

Line 1105: , p_control_rec IN inv_globals.control_rec_type

1101: -- Trolins
1102:
1103: PROCEDURE trolins(
1104: p_validation_level IN NUMBER
1105: , p_control_rec IN inv_globals.control_rec_type
1106: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type
1107: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type
1108: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type
1109: , p_move_order_type IN NUMBER

Line 1115: l_control_rec inv_globals.control_rec_type;

1111: , x_old_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1112: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130
1113: ) IS
1114: l_return_status VARCHAR2(1);
1115: l_control_rec inv_globals.control_rec_type;
1116: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1117: --Bug #4347016
1118: l_tmp_trolin_rec inv_move_order_pub.trolin_rec_type;
1119: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;

Line 1198: l_control_rec := inv_globals.init_control_rec(p_operation => l_trolin_rec.operation, p_control_rec => p_control_rec);

1194: l_old_trolin_rec := inv_move_order_pub.g_miss_trolin_rec;
1195: END IF;
1196:
1197: -- Load API control record
1198: l_control_rec := inv_globals.init_control_rec(p_operation => l_trolin_rec.operation, p_control_rec => p_control_rec);
1199: -- load header information record
1200: --l_trohdr_rec := inv_trohdr_util.query_row(l_trolin_tbl(I).header_id);
1201: --l_move_order_type := l_trohdr_rec.move_order_type;
1202:

Line 1210: IF l_trolin_rec.operation = inv_globals.g_opr_create THEN

1206: IF (l_debug = 1) THEN
1207: DEBUG('Trolin operation:'|| l_trolin_rec.operation, 'Inv_Transfer_Order_PVT.Trolins');
1208: END IF;
1209:
1210: IF l_trolin_rec.operation = inv_globals.g_opr_create THEN
1211: l_trolin_rec.db_flag := fnd_api.g_false;
1212: -- Set missing old record elements to NULL.
1213: --debug('Trolin convert');
1214: IF (l_debug = 1) THEN

Line 1218: ELSIF l_trolin_rec.operation = inv_globals.g_opr_update

1214: IF (l_debug = 1) THEN
1215: DEBUG('Trolin convert', 'Inv_Transfer_Order_PVT.Trolins');
1216: END IF;
1217: l_old_trolin_rec := inv_trolin_util.convert_miss_to_null(l_old_trolin_rec);
1218: ELSIF l_trolin_rec.operation = inv_globals.g_opr_update
1219: OR l_trolin_rec.operation = inv_globals.g_opr_delete THEN
1220: l_trolin_rec.db_flag := fnd_api.g_true;
1221:
1222: -- Query Old if missing

Line 1219: OR l_trolin_rec.operation = inv_globals.g_opr_delete THEN

1215: DEBUG('Trolin convert', 'Inv_Transfer_Order_PVT.Trolins');
1216: END IF;
1217: l_old_trolin_rec := inv_trolin_util.convert_miss_to_null(l_old_trolin_rec);
1218: ELSIF l_trolin_rec.operation = inv_globals.g_opr_update
1219: OR l_trolin_rec.operation = inv_globals.g_opr_delete THEN
1220: l_trolin_rec.db_flag := fnd_api.g_true;
1221:
1222: -- Query Old if missing
1223: IF l_old_trolin_rec.line_id = fnd_api.g_miss_num THEN

Line 1321: IF l_trolin_rec.operation = inv_globals.g_opr_delete THEN

1317: --debug('AFter Trolin APply attr');
1318:
1319: -- Entity level validation.
1320: IF l_control_rec.validate_entity THEN
1321: IF l_trolin_rec.operation = inv_globals.g_opr_delete THEN
1322: inv_validate_trolin.entity_delete(x_return_status => l_return_status, p_trolin_rec => l_trolin_rec);
1323: ELSE
1324: --debug('Trolin Validate Entity');
1325: IF (l_debug = 1) THEN

Line 1406: IF l_trolin_rec.operation = inv_globals.g_opr_delete THEN

1402: END IF;
1403:
1404: -- Step 4. Write to DB
1405: IF l_control_rec.write_to_db THEN
1406: IF l_trolin_rec.operation = inv_globals.g_opr_delete THEN
1407: --debug('Calling inv_mold_query_rows');
1408: IF (l_debug = 1) THEN
1409: DEBUG('Calling inv_mold_query_rows for Line Id: ' || to_char(l_trolin_rec.line_id), 'Inv_Transfer_Order_PVT.Trolins');
1410: END IF;

Line 1429: ELSIF l_trolin_rec.operation = inv_globals.g_opr_update THEN

1425: END IF;
1426: END IF;
1427:
1428: inv_trolin_util.delete_row(p_line_id => l_trolin_rec.line_id);
1429: ELSIF l_trolin_rec.operation = inv_globals.g_opr_update THEN
1430: -- Get Who Information
1431: -- Bug 3030538. Creation_date becomes null when both an update and
1432: -- create are done in move orders form
1433:

Line 1503: ELSIF l_trolin_rec.operation = inv_globals.g_opr_create THEN

1499: inv_trolin_util.update_row(l_trolin_rec);
1500: IF (l_debug = 1) THEN
1501: DEBUG('after update row', 'Inv_Transfer_Order_PVT.Trolins');
1502: END IF;
1503: ELSIF l_trolin_rec.operation = inv_globals.g_opr_create THEN
1504: l_trolin_rec.creation_date := SYSDATE;
1505: l_trolin_rec.created_by := fnd_global.user_id;
1506: l_trolin_rec.last_update_date := SYSDATE;
1507: l_trolin_rec.last_updated_by := fnd_global.user_id;

Line 1697: , p_control_rec IN inv_globals.control_rec_type := inv_globals.g_miss_control_rec

1693: p_api_version_number IN NUMBER
1694: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1695: , p_commit IN VARCHAR2 := fnd_api.g_false
1696: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1697: , p_control_rec IN inv_globals.control_rec_type := inv_globals.g_miss_control_rec
1698: , x_return_status OUT NOCOPY VARCHAR2
1699: , x_msg_count OUT NOCOPY NUMBER
1700: , x_msg_data OUT NOCOPY VARCHAR2
1701: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec

Line 1714: l_control_rec inv_globals.control_rec_type;

1710: ) IS
1711: l_api_version_number CONSTANT NUMBER := 1.0;
1712: l_api_name CONSTANT VARCHAR2(30) := 'Process_Transfer_Order';
1713: l_return_status VARCHAR2(1);
1714: l_control_rec inv_globals.control_rec_type;
1715: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
1716: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
1717: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1718: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

Line 1752: IF (p_control_rec.process_entity = inv_globals.g_entity_all

1748: l_trolin_tbl := p_trolin_tbl;
1749: l_old_trolin_tbl := p_old_trolin_tbl;
1750:
1751: -- Trohdr
1752: IF (p_control_rec.process_entity = inv_globals.g_entity_all
1753: OR p_control_rec.process_entity = inv_globals.g_entity_trohdr
1754: ) THEN
1755: trohdr(
1756: p_validation_level => p_validation_level

Line 1753: OR p_control_rec.process_entity = inv_globals.g_entity_trohdr

1749: l_old_trolin_tbl := p_old_trolin_tbl;
1750:
1751: -- Trohdr
1752: IF (p_control_rec.process_entity = inv_globals.g_entity_all
1753: OR p_control_rec.process_entity = inv_globals.g_entity_trohdr
1754: ) THEN
1755: trohdr(
1756: p_validation_level => p_validation_level
1757: , p_control_rec => p_control_rec

Line 1777: IF l_trolin_rec.operation = inv_globals.g_opr_create

1773:
1774: FOR i IN 1 .. l_trolin_tbl.COUNT LOOP
1775: l_trolin_rec := l_trolin_tbl(i);
1776:
1777: IF l_trolin_rec.operation = inv_globals.g_opr_create
1778: AND (l_trolin_rec.header_id IS NULL
1779: OR l_trolin_rec.header_id = fnd_api.g_miss_num
1780: ) THEN
1781: -- Copy parent_id.

Line 1792: IF (p_control_rec.process_entity = inv_globals.g_entity_all

1788: END LOOP;
1789:
1790: -- Trolins
1791:
1792: IF (p_control_rec.process_entity = inv_globals.g_entity_all
1793: OR p_control_rec.process_entity = inv_globals.g_entity_trolin
1794: ) THEN
1795: trolins(
1796: p_validation_level => p_validation_level

Line 1793: OR p_control_rec.process_entity = inv_globals.g_entity_trolin

1789:
1790: -- Trolins
1791:
1792: IF (p_control_rec.process_entity = inv_globals.g_entity_all
1793: OR p_control_rec.process_entity = inv_globals.g_entity_trolin
1794: ) THEN
1795: trolins(
1796: p_validation_level => p_validation_level
1797: , p_control_rec => p_control_rec

Line 1820: IF (p_control_rec.process_entity = inv_globals.g_entity_all

1816:
1817:
1818: --Bug #4777248
1819: --Modified both the if loops by removing p_control_rec.process from the condition
1820: IF (p_control_rec.process_entity = inv_globals.g_entity_all
1821: OR p_control_rec.process_entity = inv_globals.g_entity_trohdr
1822: ) THEN
1823: IF l_trohdr_rec.return_status = fnd_api.g_ret_sts_error THEN
1824: x_return_status := fnd_api.g_ret_sts_error;

Line 1821: OR p_control_rec.process_entity = inv_globals.g_entity_trohdr

1817:
1818: --Bug #4777248
1819: --Modified both the if loops by removing p_control_rec.process from the condition
1820: IF (p_control_rec.process_entity = inv_globals.g_entity_all
1821: OR p_control_rec.process_entity = inv_globals.g_entity_trohdr
1822: ) THEN
1823: IF l_trohdr_rec.return_status = fnd_api.g_ret_sts_error THEN
1824: x_return_status := fnd_api.g_ret_sts_error;
1825: END IF;

Line 1828: IF (p_control_rec.process_entity = inv_globals.g_entity_all

1824: x_return_status := fnd_api.g_ret_sts_error;
1825: END IF;
1826: END IF;
1827:
1828: IF (p_control_rec.process_entity = inv_globals.g_entity_all
1829: OR p_control_rec.process_entity = inv_globals.g_entity_trolin
1830: ) THEN
1831: FOR i IN 1 .. l_trolin_tbl.COUNT LOOP
1832: --debug('In Loop :'||to_char(I));

Line 1829: OR p_control_rec.process_entity = inv_globals.g_entity_trolin

1825: END IF;
1826: END IF;
1827:
1828: IF (p_control_rec.process_entity = inv_globals.g_entity_all
1829: OR p_control_rec.process_entity = inv_globals.g_entity_trolin
1830: ) THEN
1831: FOR i IN 1 .. l_trolin_tbl.COUNT LOOP
1832: --debug('In Loop :'||to_char(I));
1833: IF l_trolin_tbl(i).return_status = fnd_api.g_ret_sts_error THEN

Line 1908: IF p_trohdr_rec.operation = inv_globals.g_opr_lock THEN

1904: -- Set Savepoint
1905: SAVEPOINT lock_transfer_order_pvt;
1906:
1907: -- Lock trohdr
1908: IF p_trohdr_rec.operation = inv_globals.g_opr_lock THEN
1909: inv_trohdr_util.lock_row(p_trohdr_rec => p_trohdr_rec, x_trohdr_rec => x_trohdr_rec, x_return_status => l_return_status);
1910:
1911: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1912: RAISE fnd_api.g_exc_unexpected_error;

Line 1920: IF p_trolin_tbl(i).operation = inv_globals.g_opr_lock THEN

1916: END IF;
1917:
1918: -- Lock trolin
1919: FOR i IN 1 .. p_trolin_tbl.COUNT LOOP
1920: IF p_trolin_tbl(i).operation = inv_globals.g_opr_lock THEN
1921: inv_trolin_util.lock_row(p_trolin_rec => p_trolin_tbl(i), x_trolin_rec => l_trolin_rec, x_return_status => l_return_status);
1922:
1923: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1924: RAISE fnd_api.g_exc_unexpected_error;

Line 4781: IF ( (l_mmtt_rec.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder) AND

4777: --l_InvPCInRecType.transaction_id needs to be preserved for each call to Set_Inv_PC_Attributes
4778: l_InvPCInRecType.source_code :='INV';
4779: l_InvPCInRecType.api_version_number :=1.0;
4780:
4781: IF ( (l_mmtt_rec.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder) AND
4782: (l_mmtt_rec.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr) ) THEN
4783: -- Call to new api to check if item is catch weight enabled.
4784: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.Get_Ont_Pricing_Qty_Source (
4785: p_api_version => 1.0

Line 4782: (l_mmtt_rec.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr) ) THEN

4778: l_InvPCInRecType.source_code :='INV';
4779: l_InvPCInRecType.api_version_number :=1.0;
4780:
4781: IF ( (l_mmtt_rec.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder) AND
4782: (l_mmtt_rec.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr) ) THEN
4783: -- Call to new api to check if item is catch weight enabled.
4784: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.Get_Ont_Pricing_Qty_Source (
4785: p_api_version => 1.0
4786: , x_return_status => x_return_status

Line 4872: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

4868: mtl_transaction_lots_temp mtlt
4869: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
4870: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
4871: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
4872: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
4873: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
4874: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
4875: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
4876: AND mtlt.lot_number = l_lot_number

Line 4873: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

4869: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
4870: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
4871: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
4872: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
4873: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
4874: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
4875: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
4876: AND mtlt.lot_number = l_lot_number
4877: AND (mtlt.secondary_quantity IS NULL OR mtlt.secondary_unit_of_measure IS NULL) );

Line 5116: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

5112: FROM mtl_material_transactions_temp mmtt
5113: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
5114: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
5115: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
5116: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
5117: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
5118: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
5119: AND (mmtt.secondary_transaction_quantity IS NULL OR mmtt.secondary_uom_code IS NULL) );
5120: EXCEPTION

Line 5117: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

5113: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
5114: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
5115: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
5116: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
5117: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
5118: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
5119: AND (mmtt.secondary_transaction_quantity IS NULL OR mmtt.secondary_uom_code IS NULL) );
5120: EXCEPTION
5121: WHEN OTHERS THEN

Line 5356: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

5352: mtl_transaction_lots_temp mtlt
5353: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
5354: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
5355: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
5356: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
5357: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
5358: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
5359: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
5360: AND mtlt.lot_number = l_lot_number

Line 5357: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

5353: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
5354: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
5355: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
5356: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
5357: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
5358: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
5359: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
5360: AND mtlt.lot_number = l_lot_number
5361: AND (mtlt.secondary_quantity IS NULL OR mtlt.secondary_unit_of_measure IS NULL) );

Line 5471: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

5467: FROM mtl_material_transactions_temp mmtt
5468: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
5469: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
5470: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
5471: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
5472: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
5473: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
5474: AND (mmtt.secondary_transaction_quantity IS NULL OR mmtt.secondary_uom_code IS NULL) );
5475: EXCEPTION

Line 5472: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

5468: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
5469: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
5470: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
5471: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
5472: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
5473: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
5474: AND (mmtt.secondary_transaction_quantity IS NULL OR mmtt.secondary_uom_code IS NULL) );
5475: EXCEPTION
5476: WHEN OTHERS THEN