DBA Data[Home] [Help]

APPS.MTL_LOT_UOM_CONV_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 866: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (

862: /*=============================
863: Insert to Temp Table.
864: =============================*/
865:
866: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (
867: transaction_header_id,
868: transaction_temp_id,
869: transaction_type_id,
870: transaction_action_id,

Line 1495: FROM mtl_material_transactions_temp

1491: ============================================*/
1492:
1493: CURSOR c_check_mmtt IS
1494: SELECT 1
1495: FROM mtl_material_transactions_temp
1496: WHERE lot_number = p_lot_number
1497: AND inventory_item_id = p_inventory_item_id
1498: AND organization_id = p_organization_id;
1499:

Line 1502: FROM mtl_material_transactions_temp

1498: AND organization_id = p_organization_id;
1499:
1500: CURSOR c_check_mmtt_head IS
1501: SELECT 1
1502: FROM mtl_material_transactions_temp
1503: WHERE lot_number = p_lot_number
1504: AND inventory_item_id = p_inventory_item_id
1505: AND organization_id = p_organization_id
1506: AND transaction_header_id <> p_header_id