APPS.PA_ADJUSTMENTS dependencies on PA_COST_DISTRIBUTION_LINES

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 3714: /* R12 changes - Removed table pa_cost_distribution_lines */

3710: , pa_expenditure_items_all ei
3711: , pa_expenditure_items_all ei2
3712: , pa_transaction_sources ts
3713: , pa_expenditure_comments ec
3714: /* R12 changes - Removed table pa_cost_distribution_lines */
3715: WHERE
3716: e.expenditure_id = ei.expenditure_id
3717: AND ei.expenditure_item_id = ei2.expenditure_item_id
3718: /* R12 Changes - Removed join conditions for pa_cost_distribution_lines table */

Line 3718: /* R12 Changes - Removed join conditions for pa_cost_distribution_lines table */

3714: /* R12 changes - Removed table pa_cost_distribution_lines */
3715: WHERE
3716: e.expenditure_id = ei.expenditure_id
3717: AND ei.expenditure_item_id = ei2.expenditure_item_id
3718: /* R12 Changes - Removed join conditions for pa_cost_distribution_lines table */
3719: AND ei2.transaction_source = ts.transaction_source (+)
3720: AND ei.expenditure_item_id = X_expenditure_item_id
3721: AND ec.expenditure_item_id (+)= ei.expenditure_item_id ;
3722:

Line 5887: || ' from pa_cost_distribution_lines cdl1'

5883: || ' ,''PO RECEIPT'',''PO RECEIPT NRTAX'''
5884: || ' ,''PO RECEIPT NRTAX PRICE ADJ'''
5885: || ' ,''PO RECEIPT PRICE ADJ'')'
5886: || ' AND EXISTS (select NULL'
5887: || ' from pa_cost_distribution_lines cdl1'
5888: || ' where cdl1.expenditure_item_id = ei.expenditure_item_id'
5889: || ' and cdl1.line_num = 1'
5890: || ' and NVL(cdl1.reversed_flag,''N'') <> ''Y'')'
5891: || ' AND ei.net_zero_adjustment_flag = ''N'''

Line 9864: FROM PA_COST_DISTRIBUTION_LINES

9860:
9861: /* this cursor gets the old ccid and gl date */
9862: CURSOR C_OLD_CCID_AND_GL_DATE_CUR(p_expenditure_item_id NUMBER) IS
9863: SELECT DR_CODE_COMBINATION_ID, GL_DATE
9864: FROM PA_COST_DISTRIBUTION_LINES
9865: WHERE EXPENDITURE_ITEM_ID = ( SELECT EXPENDITURE_ITEM_ID
9866: FROM PA_EXPENDITURE_ITEMS
9867: WHERE TRANSFERRED_FROM_EXP_ITEM_ID IS NULL
9868: START WITH EXPENDITURE_ITEM_ID = p_expenditure_item_id

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