APPS.PA_ADJUSTMENTS dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 1903: from pa_cost_distribution_lines_all cdl

1899:
1900: select expenditure_item_id
1901: from pa_expenditure_items_all peia
1902: where exists( select null
1903: from pa_cost_distribution_lines_all cdl
1904: where cdl.expenditure_item_id = peia.expenditure_item_id)
1905: start with expenditure_item_id = X_expenditure_item_id
1906: connect by prior transferred_from_exp_item_id = expenditure_item_id ;
1907:

Line 1913: from pa_cost_distribution_lines_all

1909:
1910: for rec in c2 LOOP
1911:
1912: select system_reference2 into v_system_reference2
1913: from pa_cost_distribution_lines_all
1914: where expenditure_item_id = rec.expenditure_item_id
1915: and line_num_reversed is null
1916: and reversed_flag is null
1917: and line_type = 'R';

Line 10736: FROM pa_cost_distribution_lines_all cdl2

10732: AND p_transaction_source IN ('PO RECEIPT','PO RECEIPT NRTAX',
10733: 'PO RECEIPT NRTAX PRICE ADJ','PO RECEIPT PRICE ADJ'))
10734: AND ( ei.net_zero_adjustment_flag = 'Y'
10735: OR EXISTS ( SELECT NULL
10736: FROM pa_cost_distribution_lines_all cdl2
10737: WHERE cdl2.expenditure_item_id = ei.expenditure_item_id
10738: AND cdl2.line_num = 1
10739: AND cdl2.reversed_flag = 'Y'));
10740: BEGIN