DBA Data[Home] [Help]

APPS.MTL_LOT_UOM_CONV_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 880: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (

876: /*=============================
877: Insert to Temp Table.
878: =============================*/
879:
880: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (
881: transaction_header_id,
882: transaction_temp_id,
883: transaction_type_id,
884: transaction_action_id,

Line 1513: FROM mtl_material_transactions_temp

1509: ============================================*/
1510:
1511: CURSOR c_check_mmtt IS
1512: SELECT 1
1513: FROM mtl_material_transactions_temp
1514: WHERE lot_number = p_lot_number
1515: AND inventory_item_id = p_inventory_item_id
1516: AND organization_id = p_organization_id;
1517:

Line 1520: FROM mtl_material_transactions_temp

1516: AND organization_id = p_organization_id;
1517:
1518: CURSOR c_check_mmtt_head IS
1519: SELECT 1
1520: FROM mtl_material_transactions_temp
1521: WHERE lot_number = p_lot_number
1522: AND inventory_item_id = p_inventory_item_id
1523: AND organization_id = p_organization_id
1524: AND transaction_header_id <> p_header_id