DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_INVOICE_LINES

Line 1108: ap_invoice_lines AIL,

1104: --11659317
1105: SELECT distinct(AID.accounting_event_id)
1106: INTO l_accounting_event_id
1107: FROM ap_invoice_distributions AID,
1108: ap_invoice_lines AIL,
1109: xla_events xe
1110: WHERE AID.accounting_date = event_dist_rec.accounting_date
1111: AND AIL.invoice_id = P_invoice_id
1112: AND AIL.line_number = event_dist_rec.invoice_line_number

Line 7926: FROM ap_invoice_lines AIL,

7922: SELECT AIL.amount,
7923: AIL.invoice_id,
7924: AIL.line_number,
7925: AIL.org_id
7926: FROM ap_invoice_lines AIL,
7927: ap_invoice_distributions AID,
7928: ap_invoice_distributions AID1
7929: WHERE AID.invoice_id = p_invoice_id
7930: AND AID.invoice_line_number = p_invoice_line_number

Line 7962: FROM ap_invoice_lines AIL

7958: INTO l_sum_amount,
7959: l_prepay_invoice_id,
7960: l_prepay_line_number,
7961: l_org_id
7962: FROM ap_invoice_lines AIL
7963: WHERE AIL.invoice_id = P_invoice_id
7964: AND AIL.line_type_lookup_code = 'PREPAY'
7965: AND AIL.line_number = P_invoice_line_number;
7966: