DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_CUR_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1164: FROM mtl_material_transactions

1160: -- updated by amy to fix bug 5506431
1161: --SELECT actual_cost
1162: SELECT DISTINCT actual_cost
1163: INTO l_unit_cost_frozen
1164: FROM mtl_material_transactions
1165: WHERE trx_source_line_id = l_reference_line_id
1166: AND source_code = 'ORDER ENTRY'
1167: AND inventory_item_id = l_item_id
1168: AND organization_id= l_om_ship_from_org_id

Line 1178: FROM mtl_material_transactions

1174: -- updated by amy to fix bug 5506431
1175: --SELECT actual_cost
1176: SELECT DISTINCT actual_cost
1177: INTO l_unit_cost_plan
1178: FROM mtl_material_transactions
1179: WHERE trx_source_line_id =l_rcv_line_id
1180: AND source_code = 'RCV'
1181: AND rcv_transaction_id = l_rcv_transaction_id ;
1182: