APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 722: , mtl_transaction_lots_temp mtlt

718: BEGIN
719: SELECT msik.lot_split_enabled
720: INTO l_validation_status
721: FROM mtl_system_items_b msik
722: , mtl_transaction_lots_temp mtlt
723: , mtl_material_transactions_temp mmtt
724: WHERE mmtt.organization_id = p_organization_id
725: AND mmtt.inventory_item_id = p_inventory_item_id
726: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 771: , mtl_transaction_lots_temp mln

767: BEGIN
768: SELECT msik.lot_merge_enabled
769: INTO l_validation_status
770: FROM mtl_system_items_b msik
771: , mtl_transaction_lots_temp mln
772: , mtl_material_transactions_temp mmtt
773: WHERE mmtt.organization_id = p_organization_id
774: AND mmtt.inventory_item_id = p_inventory_item_id
775: AND mmtt.transaction_temp_id = mln.transaction_temp_id

Line 821: , mtl_transaction_lots_temp mln

817: BEGIN
818: SELECT DECODE (msik.lot_control_code, 2, 'Y', 'N')
819: INTO l_validation_status
820: FROM mtl_system_items_b msik
821: , mtl_transaction_lots_temp mln
822: , mtl_material_transactions_temp mmtt
823: WHERE mmtt.organization_id = p_organization_id
824: AND mmtt.inventory_item_id = p_inventory_item_id
825: AND mmtt.transaction_temp_id = mln.transaction_temp_id

Line 1064: FROM mtl_transaction_lots_temp mtlt

1060: END IF;
1061:
1062: SELECT COUNT (1)
1063: INTO l_lot_count
1064: FROM mtl_transaction_lots_temp mtlt
1065: , mtl_material_transactions_temp mmtt
1066: WHERE mmtt.inventory_item_id <> p_inventory_item_id
1067: AND mmtt.organization_id = p_organization_id
1068: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 1130: FROM mtl_transaction_lots_temp mtlt

1126: END IF;
1127:
1128: SELECT COUNT (1)
1129: INTO l_lot_count
1130: FROM mtl_transaction_lots_temp mtlt
1131: , mtl_material_transactions_temp mmtt
1132: WHERE mmtt.inventory_item_id <> p_inventory_item_id
1133: AND mmtt.organization_id = p_organization_id
1134: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 1190: FROM mtl_transaction_lots_temp mtlt

1186: END IF;
1187:
1188: SELECT COUNT (1)
1189: INTO l_lot_count
1190: FROM mtl_transaction_lots_temp mtlt
1191: , mtl_material_transactions_temp mmtt
1192: WHERE mmtt.inventory_item_id = p_inventory_item_id
1193: AND mmtt.organization_id = p_organization_id
1194: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 1311: FROM MTL_TRANSACTION_LOTS_TEMP MTLT, MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

1307: print_debug('after validating against wip_entities', 'validate_result_lot');
1308: END IF;
1309: SELECT COUNT(1)
1310: INTO l_lot_count
1311: FROM MTL_TRANSACTION_LOTS_TEMP MTLT, MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
1312: WHERE mmtt.inventory_item_id = p_inventory_item_id
1313: AND mmtt.organization_id = p_organization_id
1314: AND Mmtt.transaction_temp_id = MTLT.transaction_temp_id
1315: AND mtlt.lot_number = p_rs_lot_num_tbl(1);

Line 1326: print_debug('after validating against mtl_transaction_lots_temp', 'validate_result_lot');

1322: else
1323: l_validation_status := 'Y';
1324: end if;
1325: IF (l_debug = 1) THEN
1326: print_debug('after validating against mtl_transaction_lots_temp', 'validate_result_lot');
1327: END IF;
1328: else
1329: l_validation_status := 'Y';
1330: end if;