DBA Data[Home] [Help]

APPS.CST_ITEMRESOURCECOSTS_GRP dependencies on MTL_MATERIAL_TRANSACTIONS

Line 144: from mtl_material_transactions

140: l_stmt_num := 40;
141:
142: select avg(transaction_cost)
143: into x_item_cost
144: from mtl_material_transactions
145: where transaction_id in
146: ( select transaction_id
147: from
148: ( select transaction_id

Line 149: from mtl_material_transactions

145: where transaction_id in
146: ( select transaction_id
147: from
148: ( select transaction_id
149: from mtl_material_transactions
150: where transaction_action_id = 27
151: and transaction_source_type_id = 1
152: and organization_id = p_organization_id
153: and inventory_item_id = p_item_id