APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 720: , mtl_material_transactions_temp mmtt

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

Line 769: , mtl_material_transactions_temp mmtt

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

Line 819: , mtl_material_transactions_temp mmtt

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

Line 1062: , mtl_material_transactions_temp mmtt

1058:
1059: SELECT COUNT (1)
1060: INTO l_lot_count
1061: FROM mtl_transaction_lots_temp mtlt
1062: , mtl_material_transactions_temp mmtt
1063: WHERE mmtt.inventory_item_id <> p_inventory_item_id
1064: AND mmtt.organization_id = p_organization_id
1065: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
1066: AND mtlt.lot_number = p_rs_lot_num_tbl (i);

Line 1121: , mtl_material_transactions_temp mmtt

1117:
1118: SELECT COUNT (1)
1119: INTO l_lot_count
1120: FROM mtl_transaction_lots_temp mtlt
1121: , mtl_material_transactions_temp mmtt
1122: WHERE mmtt.inventory_item_id <> p_inventory_item_id
1123: AND mmtt.organization_id = p_organization_id
1124: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
1125: AND mtlt.lot_number = p_rs_lot_num_tbl (1);

Line 1162: , mtl_material_transactions_temp mmtt

1158:
1159: SELECT COUNT (1)
1160: INTO l_lot_count
1161: FROM mtl_transaction_lots_temp mtlt
1162: , mtl_material_transactions_temp mmtt
1163: WHERE mmtt.inventory_item_id <> p_inventory_item_id
1164: AND mmtt.organization_id = p_organization_id
1165: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
1166: AND mtlt.lot_number = p_rs_lot_num_tbl (1);

Line 1222: , mtl_material_transactions_temp mmtt

1218:
1219: SELECT COUNT (1)
1220: INTO l_lot_count
1221: FROM mtl_transaction_lots_temp mtlt
1222: , mtl_material_transactions_temp mmtt
1223: WHERE mmtt.inventory_item_id = p_inventory_item_id
1224: AND mmtt.organization_id = p_organization_id
1225: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
1226: AND mtlt.lot_number = p_rs_lot_num_tbl (i);

Line 1307: , mtl_material_transactions_temp mmtt

1303:
1304: SELECT COUNT (1)
1305: INTO l_lot_count
1306: FROM mtl_transaction_lots_temp mtlt
1307: , mtl_material_transactions_temp mmtt
1308: WHERE mmtt.inventory_item_id = p_inventory_item_id
1309: AND mmtt.organization_id = p_organization_id
1310: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
1311: AND mtlt.lot_number = p_rs_lot_num_tbl (1);

Line 1375: FROM MTL_TRANSACTION_LOTS_TEMP MTLT, MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

1371: print_debug('after validating against wip_entities', 'validate_result_lot');
1372: END IF;
1373: SELECT COUNT(1)
1374: INTO l_lot_count
1375: FROM MTL_TRANSACTION_LOTS_TEMP MTLT, MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
1376: WHERE mmtt.inventory_item_id = p_inventory_item_id
1377: AND mmtt.organization_id = p_organization_id
1378: AND Mmtt.transaction_temp_id = MTLT.transaction_temp_id
1379: AND mtlt.lot_number = p_rs_lot_num_tbl(1);