[Home] [Help]
223: -- to use the minimum precision available. In our case that translates
224: -- to taking the least between the financials options precision and the
225: -- currency precision together with taking the greatest between the
226: -- financials options mac and the currency mac.
227: -- Do not use precision or mac defined in financials_system_parameters
228: -- eTax Uptake
229:
230: l_precision := l_fc_precision;
231: l_min_acct_unit := l_fc_min_acct_unit;
1813: -- MO Access Control: Added the parameter p_org_id.
1814: -- including default to the current_org_id
1815:
1816: FUNCTION Get_Inventory_Org(P_org_id Number default mo_global.get_current_org_id) return NUMBER IS
1817: inv_org_id financials_system_parameters.inventory_organization_id%TYPE;
1818: BEGIN
1819:
1820: select inventory_organization_id
1821: into inv_org_id
1818: BEGIN
1819:
1820: select inventory_organization_id
1821: into inv_org_id
1822: from financials_system_parameters
1823: where org_id = p_org_id;
1824:
1825: return(inv_org_id);
1826:
3411: FROM AP_INVOICE_DISTRIBUTIONS dist
3412: WHERE po_distribution_id = p_po_distribution_id
3413: ) aid,
3414: AP_ENCUMBRANCE_LINES ael,
3415: financials_system_parameters fsp
3416: WHERE 1=1 --aid.po_distribution_id = P_po_distribution_id --commented for bug12962585
3417: AND aid.old_distribution_id = ael.invoice_distribution_id -- added for bug12962585
3418: -- AND aid.invoice_distribution_id = ael.invoice_distribution_id --commented for bug12962585
3419: AND ( ( p_start_gl_date is not null
3444: nvl(aid.exchange_rate_variance,0) -
3445: nvl(aid.base_quantity_variance,0))
3446: FROM ap_invoice_dists_arch aid, --bug12962585, changed to old table
3447: po_distributions pd,
3448: financials_system_parameters fs
3449: where aid.po_distribution_id = p_po_distribution_id
3450: and aid.po_distribution_id = pd.po_distribution_id
3451: and nvl(aid.org_id,-1) = nvl(fs.org_id,-1)
3452: /* and fs.inv_encumbrance_type_id <> fs.purch_encumbrance_type_id Bug 14063588*/