APPS.PA_ADJUSTMENTS dependencies on PA_CUST_REV_DIST_LINES

Line 4447: pa_cust_rev_dist_lines r

4443: SELECT
4444: ei.expenditure_item_id
4445: , eia.expenditure_item_id adj_expenditure_item_id
4446: FROM
4447: pa_cust_rev_dist_lines r
4448: , pa_expenditure_items_all ei
4449: , pa_expenditure_items_all eia
4450: WHERE
4451: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)

Line 5625: || ' FROM pa_cust_rev_dist_lines_all r'

5621: if x_bill_status is not null then
5622: if x_bill_status = 'Y' then
5623: where_clause := where_clause || ' AND (ei.event_num is not null'
5624: || ' OR EXISTS (SELECT 1'
5625: || ' FROM pa_cust_rev_dist_lines_all r'
5626: || ' WHERE r.expenditure_item_id = ei.expenditure_item_id'
5627: || ' AND r.draft_invoice_num is not null'
5628: || ' HAVING sum(nvl(r.bill_trans_bill_amount, 0)) <> 0'
5629: || ' GROUP BY r.expenditure_item_id))';

Line 5633: || ' FROM pa_cust_rev_dist_lines_all r'

5629: || ' GROUP BY r.expenditure_item_id))';
5630: elsif x_bill_status = 'N' then
5631: where_clause := where_clause || ' AND (ei.event_num is not null'
5632: || ' AND NOT EXISTS (SELECT 1'
5633: || ' FROM pa_cust_rev_dist_lines_all r'
5634: || ' WHERE r.expenditure_item_id = ei.expenditure_item_id'
5635: || ' AND r.draft_invoice_num is not null'
5636: || ' HAVING sum(nvl(r.bill_trans_bill_amount, 0)) <> 0'
5637: || ' GROUP BY r.expenditure_item_id))';