APPS.PA_ADJUSTMENTS dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 1959: from pa_cost_distribution_lines_all cdl

1955:
1956: select expenditure_item_id
1957: from pa_expenditure_items_all peia
1958: where exists( select null
1959: from pa_cost_distribution_lines_all cdl
1960: where cdl.expenditure_item_id = peia.expenditure_item_id)
1961: start with expenditure_item_id = X_expenditure_item_id
1962: connect by prior transferred_from_exp_item_id = expenditure_item_id ;
1963:

Line 1969: from pa_cost_distribution_lines_all

1965:
1966: for rec in c2 LOOP
1967:
1968: select system_reference2 into v_system_reference2
1969: from pa_cost_distribution_lines_all
1970: where expenditure_item_id = rec.expenditure_item_id
1971: and line_num_reversed is null
1972: and reversed_flag is null
1973: and line_type = 'R';

Line 11065: FROM pa_cost_distribution_lines_all cdl2

11061: AND p_transaction_source IN ('PO RECEIPT','PO RECEIPT NRTAX',
11062: 'PO RECEIPT NRTAX PRICE ADJ','PO RECEIPT PRICE ADJ'))
11063: AND ( ei.net_zero_adjustment_flag = 'Y'
11064: OR EXISTS ( SELECT NULL
11065: FROM pa_cost_distribution_lines_all cdl2
11066: WHERE cdl2.expenditure_item_id = ei.expenditure_item_id
11067: AND cdl2.line_num = 1
11068: AND cdl2.reversed_flag = 'Y'));
11069: BEGIN