APPS.PA_ADJUSTMENTS dependencies on PA_COST_DISTRIBUTION_LINES

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

3616: , pa_expenditure_items_all ei
3617: , pa_expenditure_items_all ei2
3618: , pa_transaction_sources ts
3619: , pa_expenditure_comments ec
3620: /* R12 changes - Removed table pa_cost_distribution_lines */
3621: WHERE
3622: e.expenditure_id = ei.expenditure_id
3623: AND ei.expenditure_item_id = ei2.expenditure_item_id
3624: /* R12 Changes - Removed join conditions for pa_cost_distribution_lines table */

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

3620: /* R12 changes - Removed table pa_cost_distribution_lines */
3621: WHERE
3622: e.expenditure_id = ei.expenditure_id
3623: AND ei.expenditure_item_id = ei2.expenditure_item_id
3624: /* R12 Changes - Removed join conditions for pa_cost_distribution_lines table */
3625: AND ei2.transaction_source = ts.transaction_source (+)
3626: AND ei.expenditure_item_id = X_expenditure_item_id
3627: AND ec.expenditure_item_id (+)= ei.expenditure_item_id ;
3628:

Line 5743: || ' from pa_cost_distribution_lines cdl1'

5739: || ' ,''PO RECEIPT'',''PO RECEIPT NRTAX'''
5740: || ' ,''PO RECEIPT NRTAX PRICE ADJ'''
5741: || ' ,''PO RECEIPT PRICE ADJ'')'
5742: || ' AND EXISTS (select NULL'
5743: || ' from pa_cost_distribution_lines cdl1'
5744: || ' where cdl1.expenditure_item_id = ei.expenditure_item_id'
5745: || ' and cdl1.line_num = 1'
5746: || ' and NVL(cdl1.reversed_flag,''N'') <> ''Y'')'
5747: || ' AND ei.net_zero_adjustment_flag = ''N'''

Line 9581: FROM PA_COST_DISTRIBUTION_LINES

9577:
9578: /* this cursor gets the old ccid and gl date */
9579: CURSOR C_OLD_CCID_AND_GL_DATE_CUR(p_expenditure_item_id NUMBER) IS
9580: SELECT DR_CODE_COMBINATION_ID, GL_DATE
9581: FROM PA_COST_DISTRIBUTION_LINES
9582: WHERE EXPENDITURE_ITEM_ID = ( SELECT EXPENDITURE_ITEM_ID
9583: FROM PA_EXPENDITURE_ITEMS
9584: WHERE TRANSFERRED_FROM_EXP_ITEM_ID IS NULL
9585: START WITH EXPENDITURE_ITEM_ID = p_expenditure_item_id

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