DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on FND_CURRENCIES

Line 388: l_parentorg_currency fnd_currencies.currency_code%TYPE;

384: l_ext_precision NUMBER;
385: l_min_unit NUMBER;
386:
387: l_parentorg_process_org VARCHAR2(1);
388: l_parentorg_currency fnd_currencies.currency_code%TYPE;
389:
390: l_logicalorg_process_org VARCHAR2(1);
391: l_logicalorg_ou_id NUMBER;
392: l_logicalorg_currency fnd_currencies.currency_code%TYPE;

Line 392: l_logicalorg_currency fnd_currencies.currency_code%TYPE;

388: l_parentorg_currency fnd_currencies.currency_code%TYPE;
389:
390: l_logicalorg_process_org VARCHAR2(1);
391: l_logicalorg_ou_id NUMBER;
392: l_logicalorg_currency fnd_currencies.currency_code%TYPE;
393:
394: -- End Bug 5349860
395:
396: BEGIN

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

687: DECODE(l_logicalorg_process_org, 'Y', 'N', NULL), -- opm_costed_flag
688: MMT.SHIPMENT_NUMBER -- Bug 6411640
689: FROM
690: mtl_material_transactions mmt,
691: fnd_currencies curr -- Bug 5349860: OPM INVCONV: umoogala 11-Jul-2006
692: WHERE mmt.transaction_id = p_transaction_id
693: AND curr.currency_code(+) = mmt.currency_code;
694:
695: x_return_status := g_ret_sts_success;