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_CAPITAL_EVENTS_PVT dependencies on PA_PROJECT_ASSET_ASSIGNMENTS

Line 660: pa_project_asset_assignments paa,

656: SELECT pa.project_asset_id,
657: paa.task_id, --Grouping Level: If = 0, asset is assigned to project
658: t.retirement_cost_flag task_retirement_cost_flag --Will be NULL if Task ID = 0
659: FROM pa_project_assets_all pa,
660: pa_project_asset_assignments paa,
661: pa_tasks t
662: WHERE pa.project_id = x_project_id
663: AND pa.project_asset_id = paa.project_asset_id
664: AND pa.capital_event_id IS NULL

Line 680: FROM pa_project_asset_assignments paa,

676: SELECT t.task_id,
677: paa.task_id assignment_task_id,
678: t.top_task_id,
679: t.parent_task_id
680: FROM pa_project_asset_assignments paa,
681: pa_tasks t
682: WHERE paa.project_id = x_project_id
683: AND NVL(t.retirement_cost_flag,'N') = DECODE(x_event_type,'R','Y','N')
684: AND paa.project_asset_id = 0

Line 716: pa_project_asset_assignments paa

712: SELECT pa.project_asset_id,
713: pa.asset_name,
714: paa.task_id --Grouping Level: If = 0, asset is assigned to project
715: FROM pa_project_assets_all pa,
716: pa_project_asset_assignments paa
717: WHERE pa.project_id = x_project_id
718: AND pa.project_asset_id = paa.project_asset_id (+)
719: AND pa.capital_event_id IS NULL
720: AND pa.project_asset_type = DECODE(x_event_type,'C','AS-BUILT','RETIREMENT_ADJUSTMENT')

Line 821: pa_project_asset_assignments paa

817: x_task_id NUMBER,
818: x_event_type VARCHAR2) IS
819: SELECT paa.project_asset_id
820: FROM pa_project_assets_all pa,
821: pa_project_asset_assignments paa
822: WHERE pa.project_asset_id = paa.project_asset_id
823: AND pa.project_id = x_project_id
824: AND paa.project_id = x_project_id
825: AND pa.capital_event_id = x_capital_event_id

Line 873: FROM pa_project_asset_assignments

869:
870: --Determine if entire project has a 'Common' Asset Assignment
871: SELECT DECODE(COUNT(*),0,'N','Y')
872: INTO v_common_project
873: FROM pa_project_asset_assignments
874: WHERE project_id = p_project_id
875: AND task_id = 0
876: AND project_asset_id = 0;
877:

Line 1733: pa_project_asset_assignments paa

1729: /* Commented for bug 3961059 */
1730: SELECT COUNT(*)
1731: INTO v_asset_count
1732: FROM pa_project_assets_all pa,
1733: pa_project_asset_assignments paa
1734: WHERE pa.project_asset_id = paa.project_asset_id
1735: AND pa.capital_event_id = capital_event_rec.capital_event_id
1736: AND (paa.task_id = remaining_costs_rec.task_id
1737: OR paa.task_id = v_top_task_id

Line 1747: pa_project_asset_assignments paa

1743: INTO v_asset_count
1744: From Dual Where Exists
1745: (Select 1
1746: FROM pa_project_assets_all pa,
1747: pa_project_asset_assignments paa
1748: WHERE pa.project_asset_id = paa.project_asset_id
1749: AND pa.capital_event_id = capital_event_rec.capital_event_id
1750: AND (paa.task_id = remaining_costs_rec.task_id
1751: OR paa.task_id = v_top_task_id

Line 2418: FROM pa_project_asset_assignments paa

2414: AND NVL(ppa.location_id,-99) = NVL(p_location_id,NVL(ppa.location_id,-99))
2415: AND NVL(ppa.ret_target_asset_id,-99) = NVL(p_ret_target_asset_id,NVL(ppa.ret_target_asset_id,-99))
2416: AND EXISTS
2417: (SELECT 'Assignment Exists'
2418: FROM pa_project_asset_assignments paa
2419: WHERE paa.project_id = p_project_id
2420: AND (
2421: (paa.project_asset_id = ppa.project_asset_id) --Asset is specifically assigned to project or task(s)
2422: OR

Line 2433: FROM pa_project_asset_assignments paa,

2429:
2430: CURSOR task_assignments_cur (x_project_asset_id NUMBER) IS
2431: SELECT paa.project_asset_id,
2432: paa.task_id
2433: FROM pa_project_asset_assignments paa,
2434: pa_tasks pt
2435: WHERE pt.project_id = p_project_id
2436: AND paa.project_id = p_project_id
2437: AND paa.project_asset_id = x_project_asset_id

Line 2570: FROM pa_project_asset_assignments paa

2566:
2567:
2568: CURSOR common_task_cur (x_task_id NUMBER, x_top_task_id NUMBER) IS
2569: SELECT paa.task_id
2570: FROM pa_project_asset_assignments paa
2571: WHERE paa.project_id = p_project_id
2572: AND paa.task_id IN (x_task_id,x_top_task_id)
2573: AND paa.project_asset_id = 0;
2574:

Line 2599: pa_project_asset_assignments paa

2595: x_task_id NUMBER,
2596: x_event_type VARCHAR2) IS
2597: SELECT paa.project_asset_id
2598: FROM pa_project_assets_all pa,
2599: pa_project_asset_assignments paa
2600: WHERE pa.project_asset_id = paa.project_asset_id
2601: AND pa.project_id = x_project_id
2602: AND paa.project_id = x_project_id
2603: AND pa.capital_event_id = x_capital_event_id

Line 2649: FROM pa_project_asset_assignments

2645:
2646: --Determine project-level Asset Assignments exist (Specific or Common)
2647: SELECT DECODE(COUNT(*),0,'N','Y')
2648: INTO v_project_assignment
2649: FROM pa_project_asset_assignments
2650: WHERE project_id = p_project_id
2651: AND task_id = 0;
2652:
2653: --If so, all eligible costs can be attached

Line 2673: FROM pa_project_asset_assignments paa,

2669: --Determine if current task (or its Top Task) has a specific asset assignment
2670: --for an asset in the current event
2671: SELECT DECODE(COUNT(*),0,'N','Y')
2672: INTO v_task_assignment
2673: FROM pa_project_asset_assignments paa,
2674: pa_project_assets_all ppa
2675: WHERE paa.project_id = p_project_id
2676: AND paa.project_asset_id = ppa.project_asset_id
2677: AND ppa.capital_event_id = p_capital_event_id