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_PWP_INVOICE_REL dependencies on PA_TASKS

Line 213: ,PA_TASKS TASK

209: CURSOR cur_inv_unbillable IS
210: SELECT DISTINCT EI.DOCUMENT_HEADER_ID
211: FROM PA_EXPENDITURE_ITEMS EI
212: ,PA_PROJECTS PROJ
213: ,PA_TASKS TASK
214: ,PA_TASKS TOPTASK
215: WHERE proj.project_type = NVL(p_project_type ,proj.project_type)
216: AND proj.AUTO_RELEASE_PWP_INV = 'Y'
217: AND proj.segment1 BETWEEN start_project_num AND end_project_num

Line 214: ,PA_TASKS TOPTASK

210: SELECT DISTINCT EI.DOCUMENT_HEADER_ID
211: FROM PA_EXPENDITURE_ITEMS EI
212: ,PA_PROJECTS PROJ
213: ,PA_TASKS TASK
214: ,PA_TASKS TOPTASK
215: WHERE proj.project_type = NVL(p_project_type ,proj.project_type)
216: AND proj.AUTO_RELEASE_PWP_INV = 'Y'
217: AND proj.segment1 BETWEEN start_project_num AND end_project_num
218: AND PROJ.PROJECT_ID = EI.PROJECT_ID

Line 235: ,PA_TASKS TASK

231: (SELECT /*+ INDEX(EI2 PA_EXPENDITURE_ITEMS_N27)*/
232: 1
233: FROM PA_EXPENDITURE_ITEMS EI2
234: ,PA_PROJECTS PROJ
235: ,PA_TASKS TASK
236: ,PA_TASKS TOPTASK
237: WHERE EI2.DOCUMENT_HEADER_ID =EI.DOCUMENT_HEADER_ID
238: AND EI2.PROJECT_ID = PROJ.PROJECT_ID
239: AND PROJ.PROJECT_ID = TASK.PROJECT_ID

Line 236: ,PA_TASKS TOPTASK

232: 1
233: FROM PA_EXPENDITURE_ITEMS EI2
234: ,PA_PROJECTS PROJ
235: ,PA_TASKS TASK
236: ,PA_TASKS TOPTASK
237: WHERE EI2.DOCUMENT_HEADER_ID =EI.DOCUMENT_HEADER_ID
238: AND EI2.PROJECT_ID = PROJ.PROJECT_ID
239: AND PROJ.PROJECT_ID = TASK.PROJECT_ID
240: AND TASK.PROJECT_ID = EI2.PROJECT_ID

Line 694: pa_tasks task,

690: (
691: -- revnue generated but unbilled transactions exist for the AP Invoice
692: SELECT 1
693: FROM pa_projects_all proj,
694: pa_tasks task,
695: pa_tasks toptask,
696: pa_expenditure_items ei,
697: pa_cust_rev_dist_lines crdl
698: WHERE proj.project_id = task.project_id

Line 695: pa_tasks toptask,

691: -- revnue generated but unbilled transactions exist for the AP Invoice
692: SELECT 1
693: FROM pa_projects_all proj,
694: pa_tasks task,
695: pa_tasks toptask,
696: pa_expenditure_items ei,
697: pa_cust_rev_dist_lines crdl
698: WHERE proj.project_id = task.project_id
699: and task.top_task_id = toptask.task_id

Line 723: pa_tasks task,

719: SELECT 1
720: FROM
721: pa_expenditure_items ei ,
722: pa_projects_all proj,
723: pa_tasks task,
724: pa_tasks toptask
725: WHERE
726: ei.DOCUMENT_HEADER_ID = p_invoice_id
727: AND nvl(ei.net_zero_adjustment_flag,'N') <> 'Y'

Line 724: pa_tasks toptask

720: FROM
721: pa_expenditure_items ei ,
722: pa_projects_all proj,
723: pa_tasks task,
724: pa_tasks toptask
725: WHERE
726: ei.DOCUMENT_HEADER_ID = p_invoice_id
727: AND nvl(ei.net_zero_adjustment_flag,'N') <> 'Y'
728: AND ei.system_linkage_function = 'VI'

Line 748: , PA_TASKS TASK

744: , PA_CUST_REV_DIST_LINES CRDL
745: , PA_DRAFT_INVOICE_ITEMS PDII
746: , PA_DRAFT_INVOICES PDI
747: , PA_PROJECTS PRJ
748: , PA_TASKS TASK
749: , PA_TASKS TOPTASK
750: WHERE EI.PROJECT_ID = TASK.PROJECT_ID
751: AND EI.TASK_ID = TASK.TASK_ID
752: AND PRJ.PROJECT_ID = TASK.PROJECT_ID

Line 749: , PA_TASKS TOPTASK

745: , PA_DRAFT_INVOICE_ITEMS PDII
746: , PA_DRAFT_INVOICES PDI
747: , PA_PROJECTS PRJ
748: , PA_TASKS TASK
749: , PA_TASKS TOPTASK
750: WHERE EI.PROJECT_ID = TASK.PROJECT_ID
751: AND EI.TASK_ID = TASK.TASK_ID
752: AND PRJ.PROJECT_ID = TASK.PROJECT_ID
753: AND TASK.TOP_TASK_ID = TOPTASK.TASK_ID