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.PJM_TASK_AUTO_ASSIGN dependencies on PJM_DEFAULT_TASKS

Line 289: FROM pjm_default_tasks

285: , C_procured VARCHAR2
286: , C_subinv_code VARCHAR2 )
287: IS
288: SELECT task_id
289: FROM pjm_default_tasks
290: WHERE organization_id = C_org_id
291: AND project_id = C_proj_id
292: AND NVL(inventory_item_id, nvl(C_item_id,-1)) = nvl(C_item_id,-1)
293: AND NVL(po_header_id, nvl(C_po_header_id,-1)) = nvl(C_po_header_id,-1)

Line 415: FROM pjm_default_tasks

411: , C_assy_item_id NUMBER
412: , C_dept_id NUMBER )
413: IS
414: SELECT task_id
415: FROM pjm_default_tasks
416: WHERE organization_id = C_org_id
417: AND project_id = C_proj_id
418: AND NVL(standard_operation_id,
419: nvl(C_operation_id,-1)) = nvl(C_operation_id,-1)

Line 549: FROM pjm_default_tasks

545: , C_operation_id NUMBER
546: , C_dept_id NUMBER )
547: IS
548: SELECT task_id
549: FROM pjm_default_tasks
550: WHERE organization_id = C_org_id
551: AND project_id = C_proj_id
552: AND NVL(inventory_item_id, nvl(C_item_id,-1)) = nvl(C_item_id,-1)
553: AND NVL(category_id, nvl(C_cat_id,-1)) = nvl(C_cat_id,-1)

Line 745: FROM pjm_default_tasks

741: , C_cat_id NUMBER
742: , C_to_org_id NUMBER )
743: IS
744: SELECT task_id
745: FROM pjm_default_tasks
746: WHERE organization_id = c_org_id
747: AND project_id = c_proj_id
748: AND NVL(inventory_item_id, nvl(c_item_id, -1)) = nvl(c_item_id, -1)
749: AND NVL(category_id, nvl(c_cat_id, -1)) = nvl(c_cat_id, -1)