[Home] [Help]
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:
160: (SELECT /*+ parallel_index(we) index_ffs(we) */
161: DISTINCT
162: organization_id,
163: p_sysdate transaction_date
164: FROM wip_entities we
165: ) to_conv
166: WHERE nvl (conv.conversion_rate, -999) < 0 -- null is not fine
167: AND mp.organization_id = to_conv.organization_id
168: AND conv.transaction_date (+) = to_conv.transaction_date
184: (SELECT /*+ parallel_index(we) index_ffs(we) */
185: DISTINCT
186: organization_id,
187: p_sysdate transaction_date
188: FROM wip_entities we
189: ) to_conv
190: WHERE nvl (conv.sec_conversion_rate, 999) < 0 -- null is fine
191: AND mp.organization_id = to_conv.organization_id
192: AND conv.transaction_date (+) = to_conv.transaction_date
326: (SELECT /*+ parallel_index(we) index_ffs(we) */
327: DISTINCT
328: organization_id,
329: g_sysdate transaction_date
330: FROM wip_entities we
331: ) to_conv,
332: (SELECT /*+ leading (hoi) full (hoi) use_hash (gsob)
333: parallel (hoi) parallel (gsob)*/
334: DISTINCT hoi.organization_id, gsob.currency_code
1659: wdj.start_quantity start_qty,
1660: wdj.quantity_completed actual_qty_completed
1661: FROM
1662: wip_discrete_jobs wdj,
1663: wip_entities we
1664: WHERE wdj.Status_Type <> 12 -- Not closed
1665: AND we.entity_type IN (1,3, 5)
1666: AND wdj.job_type = 1 -- Standard Jobs only
1667: AND wdj.wip_entity_id = we.wip_entity_id
1681: wrs.processing_work_days start_qty,
1682: wrs.quantity_completed actual_qty_completed
1683: FROM
1684: wip_repetitive_schedules wrs,
1685: wip_entities we
1686: WHERE
1687: wrs.status_type <> 12 -- not closed
1688: AND we.entity_type = 2
1689: AND we.wip_entity_id = wrs.wip_entity_id