DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_INVOICE_LINES

Line 961: ap_invoice_lines AIL

957:
958: SELECT distinct(AID.accounting_event_id)
959: INTO l_accounting_event_id
960: FROM ap_invoice_distributions AID,
961: ap_invoice_lines AIL
962: WHERE AID.accounting_date = event_dist_rec.accounting_date
963: AND AIL.invoice_id = P_invoice_id
964: AND AIL.line_number = event_dist_rec.invoice_line_number
965: AND AIL.invoice_id = AID.invoice_id

Line 7160: FROM ap_invoice_lines AIL,

7156: SELECT AIL.amount,
7157: AIL.invoice_id,
7158: AIL.line_number,
7159: AIL.org_id
7160: FROM ap_invoice_lines AIL,
7161: ap_invoice_distributions AID,
7162: ap_invoice_distributions AID1
7163: WHERE AID.invoice_id = p_invoice_id
7164: AND AID.invoice_line_number = p_invoice_line_number

Line 7196: FROM ap_invoice_lines AIL

7192: INTO l_sum_amount,
7193: l_prepay_invoice_id,
7194: l_prepay_line_number,
7195: l_org_id
7196: FROM ap_invoice_lines AIL
7197: WHERE AIL.invoice_id = P_invoice_id
7198: AND AIL.line_type_lookup_code = 'PREPAY'
7199: AND AIL.line_number = P_invoice_line_number;
7200: