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 207: ,PA_TASKS TASK

203: CURSOR cur_inv_unbillable IS
204: SELECT /*+ leading(aha) */ DISTINCT EI.DOCUMENT_HEADER_ID -- leading Hint Added for bug#12404156
205: FROM PA_EXPENDITURE_ITEMS EI
206: ,PA_PROJECTS PROJ
207: ,PA_TASKS TASK
208: ,PA_TASKS TOPTASK
209: ,
210: ( select distinct invoice_id
211: from ap_holds_all

Line 208: ,PA_TASKS TOPTASK

204: SELECT /*+ leading(aha) */ DISTINCT EI.DOCUMENT_HEADER_ID -- leading Hint Added for bug#12404156
205: FROM PA_EXPENDITURE_ITEMS EI
206: ,PA_PROJECTS PROJ
207: ,PA_TASKS TASK
208: ,PA_TASKS TOPTASK
209: ,
210: ( select distinct invoice_id
211: from ap_holds_all
212: where hold_lookup_code = 'Pay When Paid'

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 697: pa_tasks task,

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

Line 698: pa_tasks toptask,

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

Line 726: pa_tasks task,

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

Line 727: pa_tasks toptask

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

Line 752: , PA_TASKS TASK

748: , PA_CUST_REV_DIST_LINES CRDL
749: , PA_DRAFT_INVOICE_ITEMS PDII
750: , PA_DRAFT_INVOICES PDI
751: , PA_PROJECTS PRJ
752: , PA_TASKS TASK
753: , PA_TASKS TOPTASK
754: WHERE EI.PROJECT_ID = TASK.PROJECT_ID
755: AND EI.TASK_ID = TASK.TASK_ID
756: AND PRJ.PROJECT_ID = TASK.PROJECT_ID

Line 753: , PA_TASKS TOPTASK

749: , PA_DRAFT_INVOICE_ITEMS PDII
750: , PA_DRAFT_INVOICES PDI
751: , PA_PROJECTS PRJ
752: , PA_TASKS TASK
753: , PA_TASKS TOPTASK
754: WHERE EI.PROJECT_ID = TASK.PROJECT_ID
755: AND EI.TASK_ID = TASK.TASK_ID
756: AND PRJ.PROJECT_ID = TASK.PROJECT_ID
757: AND TASK.TOP_TASK_ID = TOPTASK.TASK_ID