[Home] [Help]
192: cec.standard_cost,
193: rank() over (partition by cec.inventory_item_id, cec.organization_id, trunc(cec.last_update_date),
194: gsob.currency_code order by cec.cost_update_id desc) r
195: from cst_elemental_costs cec,
196: hr_organization_information hoi,
197: gl_sets_of_books gsob
198: where cec.organization_id = hoi.organization_id
199: and hoi.org_information_context = 'Accounting Information'
200: and hoi.org_information1 = to_char (gsob.set_of_books_id)
261: group by mmt.inventory_item_id, mmt.organization_id,
262: cql.layer_id,
263: trunc (mmt.transaction_date)) x,
264: mtl_cst_actual_cost_details mcacd,
265: hr_organization_information hoi,
266: gl_sets_of_books gsob
267: where mcacd.transaction_id = x.transaction_id
268: and mcacd.organization_id = x.organization_id
269: and mcacd.layer_id = x.layer_id
767: cec.standard_cost,
768: rank() over (partition by cec.inventory_item_id, cec.organization_id, trunc(cec.last_update_date),
769: gsob.currency_code order by cec.cost_update_id desc) r
770: from cst_elemental_costs cec,
771: hr_organization_information hoi,
772: gl_sets_of_books gsob
773: where cec.organization_id = hoi.organization_id
774: and hoi.org_information_context = 'Accounting Information'
775: and hoi.org_information1 = to_char (gsob.set_of_books_id)
851: group by mmt.inventory_item_id, mmt.organization_id,
852: cql.layer_id,
853: trunc (mmt.transaction_date)) x,
854: mtl_cst_actual_cost_details mcacd,
855: hr_organization_information hoi,
856: gl_sets_of_books gsob
857: where mcacd.transaction_id = x.transaction_id
858: and mcacd.organization_id = x.organization_id
859: and mcacd.layer_id = x.layer_id