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;
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
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;