APPS.PA_ADJUSTMENTS dependencies on PA_CUST_REV_DIST_LINES

Line 4557: pa_cust_rev_dist_lines r

4553: SELECT
4554: ei.expenditure_item_id
4555: , eia.expenditure_item_id adj_expenditure_item_id
4556: FROM
4557: pa_cust_rev_dist_lines r
4558: , pa_expenditure_items_all ei
4559: , pa_expenditure_items_all eia
4560: WHERE
4561: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)

Line 5755: || ' FROM pa_cust_rev_dist_lines_all r'

5751: if x_bill_status is not null then
5752: if x_bill_status = 'Y' then
5753: where_clause := where_clause || ' AND (ei.event_num is not null'
5754: || ' OR EXISTS (SELECT 1'
5755: || ' FROM pa_cust_rev_dist_lines_all r'
5756: || ' WHERE r.expenditure_item_id = ei.expenditure_item_id'
5757: || ' AND r.draft_invoice_num is not null'
5758: || ' HAVING sum(nvl(r.bill_trans_bill_amount, 0)) <> 0'
5759: || ' GROUP BY r.expenditure_item_id))';

Line 5763: || ' FROM pa_cust_rev_dist_lines_all r'

5759: || ' GROUP BY r.expenditure_item_id))';
5760: elsif x_bill_status = 'N' then
5761: where_clause := where_clause || ' AND (ei.event_num is null' --Bug 12709649
5762: || ' AND NOT EXISTS (SELECT 1'
5763: || ' FROM pa_cust_rev_dist_lines_all r'
5764: || ' WHERE r.expenditure_item_id = ei.expenditure_item_id'
5765: || ' AND r.draft_invoice_num is not null'
5766: || ' HAVING sum(nvl(r.bill_trans_bill_amount, 0)) <> 0'
5767: || ' GROUP BY r.expenditure_item_id))';