65: The conversion rate work table was truncated during
66: the initialization phase.
67:
68: Get the currency conversion rates based on the organizations in the
69: WIP_ENTITIES and IC_WHSE_MST tabls using the
70: fii_currency.get_global_rate_primary API for the primary global
71: currency and fii_currency.get_global_rate_secondary for the
72: secondary global currency.
73: The primary currency API:
443: whse.ORGN_CODE ,
444: jobs.COMPLETION_DATE TRANS_DATE
445: from
446: OPI_DBI_OPM_SCALED_MTL scaled,
447: ic_whse_mst whse,
448: OPI_DBI_JOBS_F jobs
449: where
450: whse.mtl_organization_id = jobs.organization_id
451: and jobs.job_id = scaled.batch_id
467: set STANDARD_VALUE_B =
468: (select f.standard_quantity * costs.total_cost
469: from opi_pmi_cost_result_gtmp costs,
470: OPI_DBI_JOBS_F jobs,
471: ic_whse_mst whse,
472: ic_item_mst_b item,
473: mtl_System_items_b msi
474: where whse.mtl_organization_id = f.organization_id
475: and whse.whse_code = costs.whse_code