DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on FND_CURRENCIES

Line 372: l_parentorg_currency fnd_currencies.currency_code%TYPE;

368: l_ext_precision NUMBER;
369: l_min_unit NUMBER;
370:
371: l_parentorg_process_org VARCHAR2(1);
372: l_parentorg_currency fnd_currencies.currency_code%TYPE;
373:
374: l_logicalorg_process_org VARCHAR2(1);
375: l_logicalorg_ou_id NUMBER;
376: l_logicalorg_currency fnd_currencies.currency_code%TYPE;

Line 376: l_logicalorg_currency fnd_currencies.currency_code%TYPE;

372: l_parentorg_currency fnd_currencies.currency_code%TYPE;
373:
374: l_logicalorg_process_org VARCHAR2(1);
375: l_logicalorg_ou_id NUMBER;
376: l_logicalorg_currency fnd_currencies.currency_code%TYPE;
377:
378: -- End Bug 5349860
379:
380: BEGIN

Line 675: fnd_currencies curr -- Bug 5349860: OPM INVCONV: umoogala 11-Jul-2006

671: DECODE(l_logicalorg_process_org, 'Y', 'N', NULL), -- opm_costed_flag
672: MMT.SHIPMENT_NUMBER -- Bug 6411640
673: FROM
674: mtl_material_transactions mmt,
675: fnd_currencies curr -- Bug 5349860: OPM INVCONV: umoogala 11-Jul-2006
676: WHERE mmt.transaction_id = p_transaction_id
677: AND curr.currency_code(+) = mmt.currency_code;
678:
679: x_return_status := g_ret_sts_success;