DBA Data[Home] [Help]

APPS.FII_AP_INV_B_C dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 551: from ap_expense_report_headers_all

547: fnd_user fnd,
548: (select vouchno,
549: case when count(1) > 1 then -1
550: else min(report_header_id) end report_header_id
551: from ap_expense_report_headers_all
552: where accounting_date >= g_start_date
553: group by vouchno) rh,
554: po_distributions_all pd,
555: po_headers_all ph,

Line 1527: FROM AP_EXPENSE_REPORT_HEADERS_ALL H

1523: (SELECT /*+ no_merge parallel(H) */
1524: VOUCHNO,
1525: CASE WHEN COUNT(*) > 1 THEN -1
1526: ELSE MIN(REPORT_HEADER_ID) END REPORT_HEADER_ID
1527: FROM AP_EXPENSE_REPORT_HEADERS_ALL H
1528: WHERE ACCOUNTING_DATE >= g_start_date
1529: GROUP BY VOUCHNO) RH,
1530: po_distributions_all pd,
1531: po_headers_all ph