[Home] [Help]
188: * 'N' -- accrual basis
189: *----------------------------------------------------*/
190: SELECT NVL(SLA_LEDGER_CASH_BASIS_FLAG, 'N')
191: INTO l_cash_basis
192: FROM ap_system_parameters_all ASP,
193: gl_sets_of_books SOB
194: WHERE asp.org_id = x_org_id
195: AND asp.set_of_books_id = sob.set_of_books_id;
196:
5326:
5327:
5328: SELECT DECODE(awt_include_tax_amt,'Y',1,'N',0,1)
5329: INTO l_Inc_AWT_For_Tax_Flag
5330: FROM ap_system_parameters_all
5331: WHERE org_id=l_invoice_line_rec.org_id
5332: AND rownum=1;
5333: ----------------------------------------------------------------------------
5334: -- Step 3 - Validate line does not contain other distributions
6785: l_max_i BINARY_INTEGER := 0;
6786: l_max_base_i BINARY_INTEGER := 0;
6787: l_max_t BINARY_INTEGER := 0;
6788: l_pa_allows_overrides VARCHAR2(1) := 'N';
6789: l_allow_po_override AP_SYSTEM_PARAMETERS.ALLOW_FLEX_OVERRIDE_FLAG%TYPE;
6790: l_error_found VARCHAR2(1) := 'N';
6791: l_error_code VARCHAR2(4000); --bug13436794, changed length to 4000 from 80
6792: l_existing_distributions NUMBER := 0;
6793: l_count_undistributed_lines NUMBER := 1;
8341: D.corrected_quantity, -- l_corrected_quantity
8342: PLL.matching_basis, -- l_match_basis /* Amount Based Matching */
8343: ail.line_source --Bug#10416960
8344: FROM ap_invoices_all AI,
8345: ap_system_parameters_all ASP,
8346: ap_invoice_distributions D,
8347: po_distributions PD,
8348: po_lines PL,
8349: po_line_types PLT, -- Amount Based Matching
8413: PLL.matching_basis, -- l_match_basis /* Amount Based Matching */
8414: NULL --line_source
8415: FROM ap_invoices_all AI,
8416: ap_invoices retain_ai, --bug 9242891 retained invoice
8417: ap_system_parameters_all ASP,
8418: ap_invoice_distributions D,
8419: ap_invoice_distributions retain_d, --bug 9242891 retainage inv dists
8420: po_distributions PD,
8421: po_lines PL,