[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;
1809: -- MO Access Control: Added the parameter p_org_id.
1810: -- including default to the current_org_id
1811:
1812: FUNCTION Get_Inventory_Org(P_org_id Number default mo_global.get_current_org_id) return NUMBER IS
1813: inv_org_id financials_system_parameters.inventory_organization_id%TYPE;
1814: BEGIN
1815:
1816: select inventory_organization_id
1817: into inv_org_id
1814: BEGIN
1815:
1816: select inventory_organization_id
1817: into inv_org_id
1818: from financials_system_parameters
1819: where org_id = p_org_id;
1820:
1821: return(inv_org_id);
1822:
3378: CURSOR po_enc_reversed_cur IS
3379: SELECT sum(nvl(ael.accounted_cr,0) - nvl(ael.accounted_dr,0) )
3380: FROM AP_INVOICE_DISTRIBUTIONS aid,
3381: AP_ENCUMBRANCE_LINES ael,
3382: financials_system_parameters fsp
3383: WHERE aid.po_distribution_id = P_po_distribution_id
3384: AND aid.invoice_distribution_id = ael.invoice_distribution_id
3385: AND ( ( p_start_gl_date is not null
3386: and p_start_gl_date <= ael.accounting_date ) or
3402: nvl(aid.exchange_rate_variance,0) -
3403: nvl(aid.base_quantity_variance,0))
3404: FROM ap_invoice_distributions aid,
3405: po_distributions pd,
3406: financials_system_parameters fs
3407: where aid.po_distribution_id = p_po_distribution_id
3408: and aid.po_distribution_id = pd.po_distribution_id
3409: and nvl(aid.org_id,-1) = nvl(fs.org_id,-1)
3410: and fs.inv_encumbrance_type_id <> fs.purch_encumbrance_type_id