DBA Data[Home] [Help]

APPS.AP_GENERATE_DISTRIBUTIONS_PKG dependencies on AP_INVOICE_LINES

Line 183: FROM AP_INVOICE_LINES AIL

179: --bugfix:4674194
180: SHIP_TO_LOCATION_ID,
181: --bug7022001
182: PAY_AWT_GROUP_ID
183: FROM AP_INVOICE_LINES AIL
184: WHERE AIL.INVOICE_ID = P_INVOICE_ID
185: AND AIL.LINE_NUMBER = NVL(P_INVOICE_LINE_NUMBER,AIL.LINE_NUMBER)
186: AND LINE_TYPE_LOOKUP_CODE IN ('ITEM','FREIGHT','MISCELLANEOUS')
187: AND NVL(AIL.GENERATE_DISTS,'N') = 'Y'

Line 212: FROM AP_INVOICE_LINES_ALL AIL

208: --Bug 6802813: Added new cursor to generate tax distributions
209: -- while navigating from 'All Distributions' button.
210: CURSOR c_tax_lines IS
211: SELECT 'Tax Lines not fully distributed'
212: FROM AP_INVOICE_LINES_ALL AIL
213: WHERE AIL.INVOICE_ID = P_INVOICE_ID
214: AND AIL.LINE_TYPE_LOOKUP_CODE = 'TAX'
215: AND AIL.amount <>
216: (SELECT nvl(sum(amount),0)

Line 735: FROM ap_invoice_lines

731: END IF;
732:
733: SELECT nvl(included_tax_amount,0)
734: INTO l_included_tax_amount
735: FROM ap_invoice_lines
736: WHERE invoice_id = p_invoice_id
737: AND line_number = p_invoice_line_number;
738:
739: l_debug_info := 'l_included_tax_amount : '||l_included_tax_amount;