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 945: , p_control_rec IN inv_globals.control_rec_type

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

Line 953: l_control_rec inv_globals.control_rec_type;

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

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

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

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

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

Line 973: ELSIF l_trohdr_rec.operation = inv_globals.g_opr_update

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

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

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

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

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

Line 993: OR l_trohdr_rec.operation = inv_globals.g_opr_create

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

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

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

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

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

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

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

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

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

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

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

Line 1102: , p_control_rec IN inv_globals.control_rec_type

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

Line 1112: l_control_rec inv_globals.control_rec_type;

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

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

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

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

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

Line 1215: ELSIF l_trolin_rec.operation = inv_globals.g_opr_update

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

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

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

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

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

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

1389: END IF;
1390:
1391: -- Step 4. Write to DB
1392: IF l_control_rec.write_to_db THEN
1393: IF l_trolin_rec.operation = inv_globals.g_opr_delete THEN
1394: --debug('Calling inv_mold_query_rows');
1395: IF (l_debug = 1) THEN
1396: DEBUG('Calling inv_mold_query_rows for Line Id: ' || to_char(l_trolin_rec.line_id), 'Inv_Transfer_Order_PVT.Trolins');
1397: END IF;

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

1412: END IF;
1413: END IF;
1414:
1415: inv_trolin_util.delete_row(p_line_id => l_trolin_rec.line_id);
1416: ELSIF l_trolin_rec.operation = inv_globals.g_opr_update THEN
1417: -- Get Who Information
1418: -- Bug 3030538. Creation_date becomes null when both an update and
1419: -- create are done in move orders form
1420:

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

1486: inv_trolin_util.update_row(l_trolin_rec);
1487: IF (l_debug = 1) THEN
1488: DEBUG('after update row', 'Inv_Transfer_Order_PVT.Trolins');
1489: END IF;
1490: ELSIF l_trolin_rec.operation = inv_globals.g_opr_create THEN
1491: l_trolin_rec.creation_date := SYSDATE;
1492: l_trolin_rec.created_by := fnd_global.user_id;
1493: l_trolin_rec.last_update_date := SYSDATE;
1494: l_trolin_rec.last_updated_by := fnd_global.user_id;

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

1680: p_api_version_number IN NUMBER
1681: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1682: , p_commit IN VARCHAR2 := fnd_api.g_false
1683: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1684: , p_control_rec IN inv_globals.control_rec_type := inv_globals.g_miss_control_rec
1685: , x_return_status OUT NOCOPY VARCHAR2
1686: , x_msg_count OUT NOCOPY NUMBER
1687: , x_msg_data OUT NOCOPY VARCHAR2
1688: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec

Line 1701: l_control_rec inv_globals.control_rec_type;

1697: ) IS
1698: l_api_version_number CONSTANT NUMBER := 1.0;
1699: l_api_name CONSTANT VARCHAR2(30) := 'Process_Transfer_Order';
1700: l_return_status VARCHAR2(1);
1701: l_control_rec inv_globals.control_rec_type;
1702: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
1703: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
1704: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1705: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

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

1735: l_trolin_tbl := p_trolin_tbl;
1736: l_old_trolin_tbl := p_old_trolin_tbl;
1737:
1738: -- Trohdr
1739: IF (p_control_rec.process_entity = inv_globals.g_entity_all
1740: OR p_control_rec.process_entity = inv_globals.g_entity_trohdr
1741: ) THEN
1742: trohdr(
1743: p_validation_level => p_validation_level

Line 1740: OR p_control_rec.process_entity = inv_globals.g_entity_trohdr

1736: l_old_trolin_tbl := p_old_trolin_tbl;
1737:
1738: -- Trohdr
1739: IF (p_control_rec.process_entity = inv_globals.g_entity_all
1740: OR p_control_rec.process_entity = inv_globals.g_entity_trohdr
1741: ) THEN
1742: trohdr(
1743: p_validation_level => p_validation_level
1744: , p_control_rec => p_control_rec

Line 1764: IF l_trolin_rec.operation = inv_globals.g_opr_create

1760:
1761: FOR i IN 1 .. l_trolin_tbl.COUNT LOOP
1762: l_trolin_rec := l_trolin_tbl(i);
1763:
1764: IF l_trolin_rec.operation = inv_globals.g_opr_create
1765: AND (l_trolin_rec.header_id IS NULL
1766: OR l_trolin_rec.header_id = fnd_api.g_miss_num
1767: ) THEN
1768: -- Copy parent_id.

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

1775: END LOOP;
1776:
1777: -- Trolins
1778:
1779: IF (p_control_rec.process_entity = inv_globals.g_entity_all
1780: OR p_control_rec.process_entity = inv_globals.g_entity_trolin
1781: ) THEN
1782: trolins(
1783: p_validation_level => p_validation_level

Line 1780: OR p_control_rec.process_entity = inv_globals.g_entity_trolin

1776:
1777: -- Trolins
1778:
1779: IF (p_control_rec.process_entity = inv_globals.g_entity_all
1780: OR p_control_rec.process_entity = inv_globals.g_entity_trolin
1781: ) THEN
1782: trolins(
1783: p_validation_level => p_validation_level
1784: , p_control_rec => p_control_rec

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

1803:
1804:
1805: --Bug #4777248
1806: --Modified both the if loops by removing p_control_rec.process from the condition
1807: IF (p_control_rec.process_entity = inv_globals.g_entity_all
1808: OR p_control_rec.process_entity = inv_globals.g_entity_trohdr
1809: ) THEN
1810: IF l_trohdr_rec.return_status = fnd_api.g_ret_sts_error THEN
1811: x_return_status := fnd_api.g_ret_sts_error;

Line 1808: OR p_control_rec.process_entity = inv_globals.g_entity_trohdr

1804:
1805: --Bug #4777248
1806: --Modified both the if loops by removing p_control_rec.process from the condition
1807: IF (p_control_rec.process_entity = inv_globals.g_entity_all
1808: OR p_control_rec.process_entity = inv_globals.g_entity_trohdr
1809: ) THEN
1810: IF l_trohdr_rec.return_status = fnd_api.g_ret_sts_error THEN
1811: x_return_status := fnd_api.g_ret_sts_error;
1812: END IF;

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

1811: x_return_status := fnd_api.g_ret_sts_error;
1812: END IF;
1813: END IF;
1814:
1815: IF (p_control_rec.process_entity = inv_globals.g_entity_all
1816: OR p_control_rec.process_entity = inv_globals.g_entity_trolin
1817: ) THEN
1818: FOR i IN 1 .. l_trolin_tbl.COUNT LOOP
1819: --debug('In Loop :'||to_char(I));

Line 1816: OR p_control_rec.process_entity = inv_globals.g_entity_trolin

1812: END IF;
1813: END IF;
1814:
1815: IF (p_control_rec.process_entity = inv_globals.g_entity_all
1816: OR p_control_rec.process_entity = inv_globals.g_entity_trolin
1817: ) THEN
1818: FOR i IN 1 .. l_trolin_tbl.COUNT LOOP
1819: --debug('In Loop :'||to_char(I));
1820: IF l_trolin_tbl(i).return_status = fnd_api.g_ret_sts_error THEN

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

1891: -- Set Savepoint
1892: SAVEPOINT lock_transfer_order_pvt;
1893:
1894: -- Lock trohdr
1895: IF p_trohdr_rec.operation = inv_globals.g_opr_lock THEN
1896: inv_trohdr_util.lock_row(p_trohdr_rec => p_trohdr_rec, x_trohdr_rec => x_trohdr_rec, x_return_status => l_return_status);
1897:
1898: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1899: RAISE fnd_api.g_exc_unexpected_error;

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

1903: END IF;
1904:
1905: -- Lock trolin
1906: FOR i IN 1 .. p_trolin_tbl.COUNT LOOP
1907: IF p_trolin_tbl(i).operation = inv_globals.g_opr_lock THEN
1908: inv_trolin_util.lock_row(p_trolin_rec => p_trolin_tbl(i), x_trolin_rec => l_trolin_rec, x_return_status => l_return_status);
1909:
1910: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1911: RAISE fnd_api.g_exc_unexpected_error;

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

4441: --l_InvPCInRecType.transaction_id needs to be preserved for each call to Set_Inv_PC_Attributes
4442: l_InvPCInRecType.source_code :='INV';
4443: l_InvPCInRecType.api_version_number :=1.0;
4444:
4445: IF ( (l_mmtt_rec.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder) AND
4446: (l_mmtt_rec.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr) ) THEN
4447: -- Call to new api to check if item is catch weight enabled.
4448: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.Get_Ont_Pricing_Qty_Source (
4449: p_api_version => 1.0

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

4442: l_InvPCInRecType.source_code :='INV';
4443: l_InvPCInRecType.api_version_number :=1.0;
4444:
4445: IF ( (l_mmtt_rec.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder) AND
4446: (l_mmtt_rec.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr) ) THEN
4447: -- Call to new api to check if item is catch weight enabled.
4448: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.Get_Ont_Pricing_Qty_Source (
4449: p_api_version => 1.0
4450: , x_return_status => x_return_status

Line 4535: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

4531: mtl_transaction_lots_temp mtlt
4532: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
4533: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
4534: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
4535: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
4536: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
4537: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
4538: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
4539: AND mtlt.lot_number = l_lot_number

Line 4536: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

4532: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
4533: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
4534: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
4535: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
4536: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
4537: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
4538: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
4539: AND mtlt.lot_number = l_lot_number
4540: AND (mtlt.secondary_quantity IS NULL OR mtlt.secondary_unit_of_measure IS NULL) );

Line 4780: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

4776: FROM mtl_material_transactions_temp mmtt
4777: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
4778: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
4779: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
4780: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
4781: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
4782: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
4783: AND (mmtt.secondary_transaction_quantity IS NULL OR mmtt.secondary_uom_code IS NULL) );
4784: EXCEPTION

Line 4781: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

4777: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
4778: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
4779: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
4780: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
4781: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
4782: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
4783: AND (mmtt.secondary_transaction_quantity IS NULL OR mmtt.secondary_uom_code IS NULL) );
4784: EXCEPTION
4785: WHEN OTHERS THEN

Line 5012: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

5008: mtl_transaction_lots_temp mtlt
5009: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
5010: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
5011: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
5012: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
5013: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
5014: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
5015: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
5016: AND mtlt.lot_number = l_lot_number

Line 5013: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr

5009: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
5010: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
5011: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
5012: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
5013: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
5014: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
5015: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
5016: AND mtlt.lot_number = l_lot_number
5017: 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