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 1652: pa_cost_distribution_lines_all pcdl,

1648: NVL(pei.transaction_source,'Projects') transaction_source
1649: --pa_xla_interface_pkg.get_source(pei.transaction_source, pei.document_payment_id) transaction_source
1650:
1651: FROM
1652: pa_cost_distribution_lines_all pcdl,
1653: pa_expenditure_items_all pei,
1654: pa_expenditure_types pet,
1655: pa_tasks pt
1656: WHERE

Line 1677: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL1,

1673: Fix is to prevent net-zeroing CDLs from being processed */
1674: AND NOT EXISTS
1675: /* Reversed CDL*/
1676: (SELECT NULL
1677: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL1,
1678: PA_COST_DISTRIBUTION_LINES_ALL CDL2
1679: WHERE CDL1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1680: AND CDL1.LINE_NUM = PCDL.LINE_NUM
1681: AND CDL1.REVERSED_FLAG = 'Y'

Line 1678: PA_COST_DISTRIBUTION_LINES_ALL CDL2

1674: AND NOT EXISTS
1675: /* Reversed CDL*/
1676: (SELECT NULL
1677: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL1,
1678: PA_COST_DISTRIBUTION_LINES_ALL CDL2
1679: WHERE CDL1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1680: AND CDL1.LINE_NUM = PCDL.LINE_NUM
1681: AND CDL1.REVERSED_FLAG = 'Y'
1682: AND CDL1.BILLABLE_FLAG = 'Y'

Line 1690: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL1,

1686: AND TRUNC(CDL1.PA_DATE) <= TRUNC(P_PA_THROUGH_DATE) /* Added for Bug 7445771 */
1687: UNION ALL
1688: /* Reversal CDL*/
1689: SELECT NULL
1690: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL1,
1691: PA_COST_DISTRIBUTION_LINES_ALL CDL2
1692: WHERE CDL1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1693: AND CDL1.REVERSED_FLAG = 'Y'
1694: AND CDL1.BILLABLE_FLAG = 'Y'

Line 1691: PA_COST_DISTRIBUTION_LINES_ALL CDL2

1687: UNION ALL
1688: /* Reversal CDL*/
1689: SELECT NULL
1690: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL1,
1691: PA_COST_DISTRIBUTION_LINES_ALL CDL2
1692: WHERE CDL1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1693: AND CDL1.REVERSED_FLAG = 'Y'
1694: AND CDL1.BILLABLE_FLAG = 'Y'
1695: AND CDL2.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID

Line 1733: PA_COST_DISTRIBUTION_LINES_ALL PCDL2

1729: AND PALD2.EXPENDITURE_ITEM_ID = EI2.ADJUSTED_EXPENDITURE_ITEM_ID
1730: AND PALD2.REVERSED_FLAG||'' = 'N')
1731: AND EXISTS (SELECT 1
1732: FROM PA_EXPENDITURE_ITEMS_ALL EI3,
1733: PA_COST_DISTRIBUTION_LINES_ALL PCDL2
1734: WHERE EI3.ADJUSTED_EXPENDITURE_ITEM_ID = EI1.EXPENDITURE_ITEM_ID
1735: AND EI3.EXPENDITURE_ITEM_ID = PCDL2.EXPENDITURE_ITEM_ID
1736: AND TRUNC(PCDL2.PA_DATE) <= TRUNC(P_PA_THROUGH_DATE))
1737: UNION ALL

Line 1748: FROM PA_COST_DISTRIBUTION_LINES_ALL PCDL2

1744: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD2
1745: WHERE PALD2.EXPENDITURE_ITEM_ID = EI1.ADJUSTED_EXPENDITURE_ITEM_ID
1746: AND PALD2.REVERSED_FLAG||'' = 'N')
1747: AND EXISTS (SELECT 1
1748: FROM PA_COST_DISTRIBUTION_LINES_ALL PCDL2
1749: WHERE PCDL2.EXPENDITURE_ITEM_ID = EI1.ADJUSTED_EXPENDITURE_ITEM_ID
1750: AND TRUNC(PCDL2.PA_DATE) <= TRUNC(P_PA_THROUGH_DATE))
1751: /* End of code changes for Bug 7445771 */
1752: )

Line 3356: pa_cost_distribution_lines_all cdl

3352: -- asset lines which are not yet interfaced to FA before uptake of R12.
3353: CURSOR un_gl_xferred_cdls (x_detail_id IN NUMBER) IS
3354: select 'X'
3355: from pa_project_asset_line_details d,
3356: pa_cost_distribution_lines_all cdl
3357: where d.PROJECT_ASSET_LINE_DETAIL_ID = x_detail_id and
3358: d.expenditure_item_id = cdl.expenditure_item_id and
3359: d.line_num = cdl.line_num and
3360: (

Line 4074: from pa_cost_distribution_lines_all pcdl,

4070:
4071: /* removed this logic from this cursor and added function is_project_eligible for this logic
4072: Change done for bug 1280252.
4073: and ( exists (select 'x' -- project has costed,uncapitalized expenditure items
4074: from pa_cost_distribution_lines_all pcdl,
4075: pa_expenditure_items_all pei,
4076: pa_tasks pat
4077: where pcdl.expenditure_item_id = pei.expenditure_item_id
4078: and pei.revenue_distributed_flag||'' = 'N'

Line 4994: FROM pa_cost_distribution_lines_all pcdl,

4990:
4991: SELECT 1 INTO dummy
4992: FROM dual
4993: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
4994: FROM pa_cost_distribution_lines_all pcdl,
4995: pa_expenditure_items_all pei,
4996: pa_tasks pat,
4997: pa_projects pp,
4998: pa_project_types pt

Line 5082: FROM pa_cost_distribution_lines_all pcdl,

5078:
5079: SELECT 1 INTO dummy
5080: FROM dual
5081: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized Retirement Cost expenditure items
5082: FROM pa_cost_distribution_lines_all pcdl,
5083: pa_expenditure_items_all pei,
5084: pa_tasks pat,
5085: pa_projects pp,
5086: pa_project_types pt

Line 5133: FROM pa_cost_distribution_lines_all pcdl,

5129:
5130: SELECT 1 INTO dummy
5131: FROM dual
5132: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
5133: FROM pa_cost_distribution_lines_all pcdl,
5134: pa_expenditure_items_all pei,
5135: --pa_tasks pat, /* bug fix :2830211 task_id is not reqd */
5136: pa_projects_all pp,
5137: pa_project_types pt

Line 5353: pa_cost_distribution_lines_all cdl

5349: -- asset lines which are not yet interfaced to FA before uptake of R12.
5350: CURSOR un_gl_xferred_cdls (x_detail_id IN NUMBER) IS
5351: select 'X'
5352: from pa_project_asset_line_details d,
5353: pa_cost_distribution_lines_all cdl
5354: where d.PROJECT_ASSET_LINE_DETAIL_ID = x_detail_id and
5355: d.expenditure_item_id = cdl.expenditure_item_id and
5356: d.line_num = cdl.line_num and
5357: (

Line 5766: pa_cost_distribution_lines_all cdl,

5762: INTO l_line_type, l_transfer_status_code, l_acct_event_id, l_denom_raw_cost, l_exchange_rate_type, l_exchange_rate,
5763: l_acct_source_code, l_transaction_source, l_gl_date, l_denom_currency_code, l_historical_flag,
5764: l_predefined_flag , l_system_reference5, l_document_distribution_id, l_document_payment_id
5765: FROM pa_expenditure_items_all ei,
5766: pa_cost_distribution_lines_all cdl,
5767: pa_transaction_sources pts
5768: WHERE cdl.expenditure_item_id = x_expenditure_item_id
5769: AND cdl.line_num = x_line_num
5770: AND cdl.expenditure_item_id = ei.expenditure_item_id

Line 5900: pa_cost_distribution_lines_all pa_cdl

5896: SELECT p_type.capital_cost_type_code
5897: INTO l_capital_cost_type
5898: FROM pa_project_types_all p_type,
5899: pa_projects_all proj,
5900: pa_cost_distribution_lines_all pa_cdl
5901: WHERE p_type.project_type = proj.project_type
5902: AND proj.project_id = pa_cdl.project_id
5903: AND pa_cdl.expenditure_item_id = x_expenditure_item_id
5904: AND pa_cdl.line_num = x_line_num