eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FAXFACE dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 1856: pa_cost_distribution_lines_all pcdl,

1852: NVL(pei.transaction_source,'Projects') transaction_source
1853: --pa_xla_interface_pkg.get_source(pei.transaction_source, pei.document_payment_id) transaction_source
1854:
1855: FROM
1856: pa_cost_distribution_lines_all pcdl,
1857: pa_expenditure_items_all pei,
1858: pa_expenditure_types pet,
1859: pa_tasks pt
1860: WHERE

Line 1881: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL1,

1877: Fix is to prevent net-zeroing CDLs from being processed */
1878: AND NOT EXISTS
1879: /* Reversed CDL*/
1880: (SELECT NULL
1881: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL1,
1882: PA_COST_DISTRIBUTION_LINES_ALL CDL2
1883: WHERE CDL1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1884: AND CDL1.LINE_NUM = PCDL.LINE_NUM
1885: AND CDL1.REVERSED_FLAG = 'Y'

Line 1882: PA_COST_DISTRIBUTION_LINES_ALL CDL2

1878: AND NOT EXISTS
1879: /* Reversed CDL*/
1880: (SELECT NULL
1881: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL1,
1882: PA_COST_DISTRIBUTION_LINES_ALL CDL2
1883: WHERE CDL1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1884: AND CDL1.LINE_NUM = PCDL.LINE_NUM
1885: AND CDL1.REVERSED_FLAG = 'Y'
1886: AND CDL1.BILLABLE_FLAG = 'Y'

Line 1907: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL1,

1903: /* End: Added for Bug 14852040 */
1904: UNION ALL
1905: /* Reversal CDL*/
1906: SELECT NULL
1907: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL1,
1908: PA_COST_DISTRIBUTION_LINES_ALL CDL2
1909: WHERE CDL1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1910: AND CDL1.REVERSED_FLAG = 'Y'
1911: AND CDL1.BILLABLE_FLAG = 'Y'

Line 1908: PA_COST_DISTRIBUTION_LINES_ALL CDL2

1904: UNION ALL
1905: /* Reversal CDL*/
1906: SELECT NULL
1907: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL1,
1908: PA_COST_DISTRIBUTION_LINES_ALL CDL2
1909: WHERE CDL1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1910: AND CDL1.REVERSED_FLAG = 'Y'
1911: AND CDL1.BILLABLE_FLAG = 'Y'
1912: AND CDL2.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID

Line 1963: PA_COST_DISTRIBUTION_LINES_ALL PCDL2

1959: AND PALD3.REVERSED_FLAG||'' = 'N')
1960: -- End: Changes for bug 14530008
1961: AND EXISTS (SELECT 1
1962: FROM PA_EXPENDITURE_ITEMS_ALL EI3,
1963: PA_COST_DISTRIBUTION_LINES_ALL PCDL2
1964: WHERE EI3.ADJUSTED_EXPENDITURE_ITEM_ID = EI1.EXPENDITURE_ITEM_ID
1965: AND EI3.EXPENDITURE_ITEM_ID = PCDL2.EXPENDITURE_ITEM_ID
1966: AND TRUNC(PCDL2.PA_DATE) <= TRUNC(P_PA_THROUGH_DATE)
1967: AND PCDL2.transfer_status_code in ('P','A','V','T','R','G','B')

Line 1981: FROM PA_COST_DISTRIBUTION_LINES_ALL PCDL2

1977: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD2
1978: WHERE PALD2.EXPENDITURE_ITEM_ID = EI1.ADJUSTED_EXPENDITURE_ITEM_ID
1979: AND PALD2.REVERSED_FLAG||'' = 'N')
1980: AND EXISTS (SELECT 1
1981: FROM PA_COST_DISTRIBUTION_LINES_ALL PCDL2
1982: WHERE PCDL2.EXPENDITURE_ITEM_ID = EI1.ADJUSTED_EXPENDITURE_ITEM_ID
1983: AND TRUNC(PCDL2.PA_DATE) <= TRUNC(P_PA_THROUGH_DATE)
1984: AND PCDL2.transfer_status_code in ('P','A','V','T','R','G','B')
1985: AND ((PCDL2.line_type = 'I' and PCDL2.transfer_status_code = 'G') OR

Line 3724: pa_cost_distribution_lines_all cdl

3720: -- asset lines which are not yet interfaced to FA before uptake of R12.
3721: CURSOR un_gl_xferred_cdls (x_detail_id IN NUMBER) IS
3722: select 'X'
3723: from pa_project_asset_line_details d,
3724: pa_cost_distribution_lines_all cdl
3725: where d.PROJECT_ASSET_LINE_DETAIL_ID = x_detail_id and
3726: d.expenditure_item_id = cdl.expenditure_item_id and
3727: d.line_num = cdl.line_num and
3728: (

Line 4458: from pa_cost_distribution_lines_all pcdl,

4454:
4455: /* removed this logic from this cursor and added function is_project_eligible for this logic
4456: Change done for bug 1280252.
4457: and ( exists (select 'x' -- project has costed,uncapitalized expenditure items
4458: from pa_cost_distribution_lines_all pcdl,
4459: pa_expenditure_items_all pei,
4460: pa_tasks pat
4461: where pcdl.expenditure_item_id = pei.expenditure_item_id
4462: and pei.revenue_distributed_flag||'' = 'N'

Line 5380: FROM pa_cost_distribution_lines_all pcdl,

5376:
5377: SELECT 1 INTO dummy
5378: FROM dual
5379: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
5380: FROM pa_cost_distribution_lines_all pcdl,
5381: pa_expenditure_items_all pei,
5382: pa_tasks pat,
5383: pa_projects pp,
5384: pa_project_types pt

Line 5468: FROM pa_cost_distribution_lines_all pcdl,

5464:
5465: SELECT 1 INTO dummy
5466: FROM dual
5467: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized Retirement Cost expenditure items
5468: FROM pa_cost_distribution_lines_all pcdl,
5469: pa_expenditure_items_all pei,
5470: pa_tasks pat,
5471: pa_projects pp,
5472: pa_project_types pt

Line 5519: FROM pa_cost_distribution_lines_all pcdl,

5515:
5516: SELECT 1 INTO dummy
5517: FROM dual
5518: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
5519: FROM pa_cost_distribution_lines_all pcdl,
5520: pa_expenditure_items_all pei,
5521: --pa_tasks pat, /* bug fix :2830211 task_id is not reqd */
5522: pa_projects_all pp,
5523: pa_project_types pt

Line 5739: pa_cost_distribution_lines_all cdl

5735: -- asset lines which are not yet interfaced to FA before uptake of R12.
5736: CURSOR un_gl_xferred_cdls (x_detail_id IN NUMBER) IS
5737: select 'X'
5738: from pa_project_asset_line_details d,
5739: pa_cost_distribution_lines_all cdl
5740: where d.PROJECT_ASSET_LINE_DETAIL_ID = x_detail_id and
5741: d.expenditure_item_id = cdl.expenditure_item_id and
5742: d.line_num = cdl.line_num and
5743: (

Line 6061: FROM pa_cost_distribution_lines_all cdl

6057: --AND billable_flag||'' = 'Y' /*Bug 13637279 commented this and added the below exists clause */
6058: AND capital_event_id IS NULL
6059: AND EXISTS
6060: (SELECT 1
6061: FROM pa_cost_distribution_lines_all cdl
6062: WHERE ei.expenditure_item_id = cdl.expenditure_item_id
6063: AND cdl.billable_flag ||''='Y'
6064: AND EXISTS
6065: (

Line 6084: FROM pa_cost_distribution_lines_all pcdl

6080: AND det.project_asset_line_detail_id = lines.project_asset_line_detail_id
6081: )
6082: UNION ALL
6083: SELECT 1
6084: FROM pa_cost_distribution_lines_all pcdl
6085: WHERE pcdl.expenditure_item_id = cdl.expenditure_item_id
6086: AND pcdl.line_num = cdl.line_num
6087: AND pcdl.reversed_flag IS NULL
6088: AND pcdl.LINE_NUM_REVERSED IS NULL

Line 6188: pa_cost_distribution_lines_all cdl,

6184: INTO l_line_type, l_transfer_status_code, l_acct_event_id, l_denom_raw_cost, l_exchange_rate_type, l_exchange_rate,
6185: l_acct_source_code, l_transaction_source, l_gl_date, l_denom_currency_code, l_historical_flag,
6186: l_predefined_flag , l_system_reference5, l_document_distribution_id, l_document_payment_id
6187: FROM pa_expenditure_items_all ei,
6188: pa_cost_distribution_lines_all cdl,
6189: pa_transaction_sources pts
6190: WHERE cdl.expenditure_item_id = x_expenditure_item_id
6191: AND cdl.line_num = x_line_num
6192: AND cdl.expenditure_item_id = ei.expenditure_item_id

Line 6346: pa_cost_distribution_lines_all pa_cdl

6342: SELECT p_type.capital_cost_type_code
6343: INTO l_capital_cost_type
6344: FROM pa_project_types_all p_type,
6345: pa_projects_all proj,
6346: pa_cost_distribution_lines_all pa_cdl
6347: WHERE p_type.project_type = proj.project_type
6348: AND proj.project_id = pa_cdl.project_id
6349: AND pa_cdl.expenditure_item_id = x_expenditure_item_id
6350: AND pa_cdl.line_num = x_line_num