DBA Data[Home] [Help]

APPS.AP_WEB_EXPORT_ER dependencies on AP_LOOKUP_CODES

Line 489: --ap_lookup_codes l1

485: h.business_group_id,
486: h.location_id
487: FROM PER_CONT_WORKERS_CURRENT_X h) emps,
488: ap_suppliers V
489: --ap_lookup_codes l1
490: WHERE vouchno = 0
491: AND XH.employee_id = V.employee_id(+)
492: AND XH.employee_id = emps.employee_id(+)
493: AND (trunc(sysdate) between people.effective_start_date(+) AND

Line 2048: ap_lookup_codes lc,

2044: '' accounting_date,
2045: XL.org_id org_id
2046: FROM ap_expense_report_lines XL,
2047: gl_code_combinations gcc,
2048: ap_lookup_codes lc,
2049: fnd_currencies F,
2050: ap_expense_report_headers XH
2051: WHERE XL.report_header_id = XH.report_header_id
2052: AND XH.report_header_id = p_report_header_id

Line 2574: ap_lookup_codes lc,

2570: nvl(xl.receipt_currency_code, ''),
2571: nvl(xl.country_of_supply, '')
2572: FROM ap_expense_report_lines XL,
2573: gl_code_combinations gcc,
2574: ap_lookup_codes lc,
2575: fnd_currencies F,
2576: ap_expense_report_headers XH
2577: WHERE XL.report_header_id = XH.report_header_id
2578: AND XH.report_header_id = p_report_header_id