DBA Data[Home] [Help]

APPS.PA_INVOICE_DETAIL_PROCESS dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 1986: FROM pa_cost_distribution_lines_all cdl

1982: l_acct_tp_rate_type,
1983: l_acct_tp_exchange_rate,
1984: l_line_num,
1985: l_ind_compiled_set_id
1986: FROM pa_cost_distribution_lines_all cdl
1987: WHERE cdl.EXPENDITURE_ITEM_ID = P_EI_id(I)
1988: AND cdl.LINE_NUM_REVERSED IS NULL
1989: AND cdl.LINE_NUM = ( SELECT MAX(cdl1.LINE_NUM)
1990: FROM pa_cost_distribution_lines_all cdl1

Line 1990: FROM pa_cost_distribution_lines_all cdl1

1986: FROM pa_cost_distribution_lines_all cdl
1987: WHERE cdl.EXPENDITURE_ITEM_ID = P_EI_id(I)
1988: AND cdl.LINE_NUM_REVERSED IS NULL
1989: AND cdl.LINE_NUM = ( SELECT MAX(cdl1.LINE_NUM)
1990: FROM pa_cost_distribution_lines_all cdl1
1991: WHERE cdl1.EXPENDITURE_ITEM_ID =
1992: cdl.EXPENDITURE_ITEM_ID
1993: AND cdl.LINE_NUM_REVERSED IS NULL
1994: AND cdl1.line_type = 'R' );