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_EXPENDITURE_ITEMS_ALL

Line 527: pa_expenditure_items_all pei

523: x_err_code := 0;
524: x_err_stage := 'Updating the expenditure_items';
525:
526: UPDATE
527: pa_expenditure_items_all pei
528: SET
529: revenue_distributed_flag = x_revenue_distributed_flag,
530: last_update_date = sysdate,
531: last_updated_by = x_last_updated_by,

Line 1653: pa_expenditure_items_all pei,

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
1657: pcdl.expenditure_item_id = pei.expenditure_item_id

Line 1709: FROM PA_EXPENDITURE_ITEMS_ALL EI1

1705: AND PALD1.REVERSED_FLAG ||'' = 'N')
1706: UNION ALL
1707: /* For ei adjustment e.g. transfer from cap to expense task
1708: SELECT NULL
1709: FROM PA_EXPENDITURE_ITEMS_ALL EI1
1710: WHERE EI1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1711: AND EI1.NET_ZERO_ADJUSTMENT_FLAG = 'Y'
1712: /* checking if the adjusted ei has already been capitalized
1713: AND NOT EXISTS (SELECT NULL

Line 1721: FROM PA_EXPENDITURE_ITEMS_ALL EI1

1717: EI1.ADJUSTED_EXPENDITURE_ITEM_ID)
1718: AND PALD2.REVERSED_FLAG ||'' = 'N')
1719: Commented the above code and added below two selects for Bug 7445771 */
1720: SELECT NULL
1721: FROM PA_EXPENDITURE_ITEMS_ALL EI1
1722: WHERE EI1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1723: AND EI1.NET_ZERO_ADJUSTMENT_FLAG = 'Y'
1724: AND EI1.ADJUSTED_EXPENDITURE_ITEM_ID IS NULL
1725: AND NOT EXISTS (SELECT NULL

Line 1727: PA_EXPENDITURE_ITEMS_ALL EI2

1723: AND EI1.NET_ZERO_ADJUSTMENT_FLAG = 'Y'
1724: AND EI1.ADJUSTED_EXPENDITURE_ITEM_ID IS NULL
1725: AND NOT EXISTS (SELECT NULL
1726: FROM PA_PROJECT_ASSET_LINE_DETAILS PALD2,
1727: PA_EXPENDITURE_ITEMS_ALL EI2
1728: WHERE EI2.ADJUSTED_EXPENDITURE_ITEM_ID = EI1.EXPENDITURE_ITEM_ID
1729: AND PALD2.EXPENDITURE_ITEM_ID = EI2.ADJUSTED_EXPENDITURE_ITEM_ID
1730: AND PALD2.REVERSED_FLAG||'' = 'N')
1731: AND EXISTS (SELECT 1

Line 1732: FROM PA_EXPENDITURE_ITEMS_ALL EI3,

1728: WHERE EI2.ADJUSTED_EXPENDITURE_ITEM_ID = EI1.EXPENDITURE_ITEM_ID
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))

Line 1739: FROM PA_EXPENDITURE_ITEMS_ALL EI1

1735: AND EI3.EXPENDITURE_ITEM_ID = PCDL2.EXPENDITURE_ITEM_ID
1736: AND TRUNC(PCDL2.PA_DATE) <= TRUNC(P_PA_THROUGH_DATE))
1737: UNION ALL
1738: SELECT NULL
1739: FROM PA_EXPENDITURE_ITEMS_ALL EI1
1740: WHERE EI1.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
1741: AND EI1.NET_ZERO_ADJUSTMENT_FLAG = 'Y'
1742: AND EI1.ADJUSTED_EXPENDITURE_ITEM_ID IS NOT NULL
1743: AND NOT EXISTS (SELECT NULL

Line 1766: AND EXISTS(select NULL from pa_expenditure_items_all ei1

1762: AND pt.project_id =p_project_id
1763: /*start of change for bug 6037734*/
1764: AND (pa_nl_installed.is_nl_installed='N'
1765: OR (pa_nl_installed.is_nl_installed='Y'
1766: AND EXISTS(select NULL from pa_expenditure_items_all ei1
1767: where ei1.expenditure_item_id = pei.expenditure_item_id
1768: and (ei1.attribute6 is not null OR ei1.attribute7 is not null OR ei1.attribute8 is not null
1769: OR ei1.attribute9 is not null OR ei1.attribute10 is not null)
1770: )

Line 1771: AND NOT EXISTS (select null from pa_expenditure_items_all ei2

1767: where ei1.expenditure_item_id = pei.expenditure_item_id
1768: and (ei1.attribute6 is not null OR ei1.attribute7 is not null OR ei1.attribute8 is not null
1769: OR ei1.attribute9 is not null OR ei1.attribute10 is not null)
1770: )
1771: AND NOT EXISTS (select null from pa_expenditure_items_all ei2
1772: where ei2.expenditure_item_id = pei.expenditure_item_id
1773: and ei2.attribute8 is NULL
1774: and ei2.attribute9 is NULL
1775: )

Line 1778: AND EXISTS(select null from pa_expenditure_items_all ei3

1774: and ei2.attribute9 is NULL
1775: )
1776: )
1777: OR (pa_nl_installed.is_nl_installed='Y'
1778: AND EXISTS(select null from pa_expenditure_items_all ei3
1779: where ei3.expenditure_item_id = pei.expenditure_item_id
1780: and ei3.attribute6 is NULL
1781: and ei3.attribute7 is NULL
1782: and ei3.attribute8 is NULL

Line 1879: curr_nlr pa_expenditure_items_all.non_labor_resource%TYPE;

1875: l_asset_id NUMBER;
1876: l_num_asset_assignment NUMBER;
1877: curr_ccid NUMBER;
1878: prev_ccid NUMBER;
1879: curr_nlr pa_expenditure_items_all.non_labor_resource%TYPE;
1880: prev_nlr pa_expenditure_items_all.non_labor_resource%TYPE;
1881: curr_expend_type VARCHAR2(100);
1882: prev_expend_type VARCHAR2(100);
1883: curr_expend_cat VARCHAR2(100);

Line 1880: prev_nlr pa_expenditure_items_all.non_labor_resource%TYPE;

1876: l_num_asset_assignment NUMBER;
1877: curr_ccid NUMBER;
1878: prev_ccid NUMBER;
1879: curr_nlr pa_expenditure_items_all.non_labor_resource%TYPE;
1880: prev_nlr pa_expenditure_items_all.non_labor_resource%TYPE;
1881: curr_expend_type VARCHAR2(100);
1882: prev_expend_type VARCHAR2(100);
1883: curr_expend_cat VARCHAR2(100);
1884: curr_grouping_method VARCHAR2(255);

Line 1895: prev_sys_link_fun pa_expenditure_items_all.system_linkage_function%TYPE;

1891: prev_asset_cost NUMBER;
1892: proj_asset_line_detail_id NUMBER;
1893: description pa_project_asset_lines.description%TYPE;
1894: depreciation_expense_ccid NUMBER;
1895: prev_sys_link_fun pa_expenditure_items_all.system_linkage_function%TYPE;
1896:
1897: curr_employee_id po_vendors.employee_id%type;
1898: curr_invoice_num ap_invoices.invoice_num%TYPE;
1899: curr_vendor_number po_vendors.segment1%TYPE;

Line 4075: pa_expenditure_items_all pei,

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'
4079: and pei.cost_distributed_flag ='Y'

Line 4995: pa_expenditure_items_all pei,

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
4999: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id

Line 5083: pa_expenditure_items_all pei,

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
5087: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id

Line 5134: pa_expenditure_items_all pei,

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
5138: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id

Line 5661: UPDATE pa_expenditure_items_all

5657: AND capital_event_id IS NULL
5658: AND capital_hold_flag = 'N';
5659:
5660: --Update all capital Expenditure Items
5661: UPDATE pa_expenditure_items_all
5662: SET capital_event_id = -1,
5663: last_update_date = SYSDATE,
5664: last_updated_by = x_last_updated_by,
5665: last_update_login = x_last_update_login,

Line 5675: UPDATE pa_expenditure_items_all peia

5671: AND billable_flag||'' = 'Y'
5672: AND capital_event_id IS NULL;
5673:
5674: --Update all retirement cost Expenditure Items
5675: UPDATE pa_expenditure_items_all peia
5676: SET capital_event_id = -1,
5677: last_update_date = SYSDATE,
5678: last_updated_by = x_last_updated_by,
5679: last_update_login = x_last_update_login,

Line 5765: FROM pa_expenditure_items_all ei,

5761: nvl(pts.predefined_flag,'Y'), cdl.system_reference5, ei.document_distribution_id, ei.document_payment_id
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