DBA Data[Home] [Help]

APPS.OPI_DBI_MTL_VARIANCE_PKG dependencies on IC_WHSE_MST

Line 69: WIP_ENTITIES and IC_WHSE_MST tabls using the

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:

Line 447: ic_whse_mst whse,

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

Line 471: ic_whse_mst whse,

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