APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 723: , mtl_material_transactions_temp mmtt

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
727: AND mtlt.lot_number = p_lot_number

Line 772: , mtl_material_transactions_temp mmtt

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
776: AND mln.lot_number = p_lot_number

Line 822: , mtl_material_transactions_temp mmtt

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
826: AND mln.lot_number = p_lot_number

Line 1065: , mtl_material_transactions_temp mmtt

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
1069: AND mtlt.lot_number = p_rs_lot_num_tbl (i);

Line 1131: , mtl_material_transactions_temp mmtt

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
1135: AND mtlt.lot_number = p_rs_lot_num_tbl (1);

Line 1191: , mtl_material_transactions_temp mmtt

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
1195: AND mtlt.lot_number = p_rs_lot_num_tbl (i);

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);