DBA Data[Home] [Help]

APPS.AP_CREDIT_CARD_INVOICE_PKG dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 607: ap_expense_report_headers_all erh

603: erl.vat_code,
604: erl.amount_includes_tax_flag
605: FROM ap_expense_report_lines_all erl,
606: ap_credit_card_trxns_all cc,
607: ap_expense_report_headers_all erh
608: WHERE erl.report_header_id = erh.report_header_id
609: AND nvl(erl.itemization_parent_id,0) <> -1 /* Itemization Project */
610: AND cc.trx_id = erl.credit_card_trx_id -- is a credit card transaction
611: AND cc.payment_due_from_code in ('BOTH','COMPANY') -- Both Pay split project