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_PROJECT_ASSETS

Line 265: pa_project_assets ppa

261: paa.project_asset_id,
262: ppa.asset_category_id
263: FROM
264: pa_project_asset_assignments paa,
265: pa_project_assets ppa
266: WHERE
267: paa.project_id = x_project_id
268: AND ppa.project_asset_type(+) = DECODE(x_line_type,'C','AS-BUILT','RETIREMENT_ADJUSTMENT')
269: AND ppa.capital_event_id(+) IS NOT NULL

Line 349: pa_project_assets

345: depreciation_expense_ccid
346: INTO
347: x_depreciation_expense_ccid
348: FROM
349: pa_project_assets
350: WHERE
351: project_asset_id = x_project_asset_id;
352:
353: EXCEPTION

Line 378: pa_project_assets ppa

374: x_err_stage := 'Finding the assets to be reversed';
375: x_asset_found := TRUE;
376:
377: UPDATE
378: pa_project_assets ppa
379: SET
380: ppa.reverse_flag = 'S'
381: WHERE
382: ppa.project_id = x_project_id

Line 438: pa_project_assets pas

434: AND pal.project_asset_id NOT IN
435: ( SELECT
436: project_asset_id
437: FROM
438: pa_project_assets pas
439: WHERE
440: pas.reverse_flag = 'S'
441: AND pas.project_id = pal.project_id
442: )

Line 456: pa_project_assets pas

452: AND pal.project_asset_id IN
453: ( SELECT
454: project_asset_id
455: FROM
456: pa_project_assets pas
457: WHERE
458: pas.reverse_flag = 'S'
459: AND pas.project_id = pal.project_id
460: )

Line 601: pa_project_assets ppa

597:
598: IF ( x_project_asset_id > 0 ) THEN
599:
600: UPDATE
601: pa_project_assets ppa
602: SET
603: ppa.grouped_cip_cost = NVL(ppa.grouped_cip_cost,0) +
604: x_grouped_cip_cost,
605: ppa.capitalized_cost = NVL(ppa.capitalized_cost,0) +

Line 823: pa_project_assets pas

819: AND pal.project_asset_id IN
820: ( SELECT
821: project_asset_id
822: FROM
823: pa_project_assets pas
824: WHERE
825: pas.reverse_flag = 'S'
826: AND pas.project_id = pal.project_id
827: )

Line 889: pa_project_assets pas

885: AND pal.project_asset_id IN
886: ( SELECT
887: project_asset_id
888: FROM
889: pa_project_assets pas
890: WHERE
891: pas.reverse_flag = 'S'
892: AND pas.project_id = pal.project_id
893: )

Line 1105: pa_project_assets

1101: -- At this time Project_asset_lines are reversed
1102: -- we need to interface the adjustment lines to FA now
1103:
1104: UPDATE
1105: pa_project_assets
1106: SET
1107: reverse_flag = 'N',
1108: /* Automatic asset capitalization changes JPULTORAK 04-FEB-03 */
1109: --Commenting out this line since it is counter to business flow and erases key data (DPIS)

Line 2026: FROM pa_project_assets ppa,

2022: )
2023: )
2024: /* end of change for bug 6037734*/
2025: AND EXISTS ( SELECT '1' -- Check for task_id to have asset assignment
2026: FROM pa_project_assets ppa,
2027: pa_project_asset_assignments paa
2028: WHERE paa.project_id = p_project_id
2029: AND paa.task_id = pt.task_id
2030: AND ppa.capital_event_id IS NOT NULL

Line 2038: FROM pa_project_assets ppa,

2034: AND ppa.project_asset_id = paa.project_asset_id
2035: AND TRUNC(ppa.date_placed_in_service) <= TRUNC(p_in_service_date_through)
2036: UNION ALL
2037: SELECT '1' -- Check for top_task_id to have asset assignment
2038: FROM pa_project_assets ppa,
2039: pa_project_asset_assignments paa
2040: WHERE paa.project_id = p_project_id
2041: AND paa.task_id = pt.top_task_id
2042: AND ppa.capital_event_id IS NOT NULL

Line 2050: FROM pa_project_assets ppa,

2046: AND ppa.project_asset_id = paa.project_asset_id
2047: AND TRUNC(ppa.date_placed_in_service) <= TRUNC(p_in_service_date_through)
2048: UNION ALL
2049: SELECT '1' -- Check for project level Asset Assignments
2050: FROM pa_project_assets ppa,
2051: pa_project_asset_assignments paa
2052: WHERE paa.project_id = p_project_id
2053: AND nvl(paa.task_id,0) = 0
2054: AND ppa.capital_event_id IS NOT NULL

Line 2101: from pa_project_assets

2097:
2098: cursor c_proj_asset(p_asset_id in number) is
2099: select project_id, date_placed_in_service, capital_event_id,
2100: capital_hold_flag, project_asset_type
2101: from pa_project_assets
2102: where project_asset_id = nvl(p_asset_id,0);
2103:
2104: l_amount_type varchar2(1) := Null;
2105: l_tbc_flag varchar2(1);

Line 2173: extn_capital_hold_flag pa_project_assets_all.capital_hold_flag%TYPE;

2169: curr_capital_event_id pa_capital_events.capital_event_id%TYPE;
2170: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;
2171: v_retirement_cost_type pa_project_asset_lines_all.retirement_cost_type%TYPE := NULL;
2172: extn_capital_event_id pa_capital_events.capital_event_id%TYPE;
2173: extn_capital_hold_flag pa_project_assets_all.capital_hold_flag%TYPE;
2174: extn_project_asset_type pa_project_assets_all.project_asset_type%TYPE;
2175:
2176: extn_project_id number(15);
2177: extn_date_in_service date;

Line 2174: extn_project_asset_type pa_project_assets_all.project_asset_type%TYPE;

2170: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;
2171: v_retirement_cost_type pa_project_asset_lines_all.retirement_cost_type%TYPE := NULL;
2172: extn_capital_event_id pa_capital_events.capital_event_id%TYPE;
2173: extn_capital_hold_flag pa_project_assets_all.capital_hold_flag%TYPE;
2174: extn_project_asset_type pa_project_assets_all.project_asset_type%TYPE;
2175:
2176: extn_project_id number(15);
2177: extn_date_in_service date;
2178: extn_error_code varchar2(1);

Line 2834: pa_project_assets ppa

2830: AND pal.line_type = x_line_type
2831: AND exists
2832: (SELECT null -- Update project asset lines belonging to new assets
2833: FROM
2834: pa_project_assets ppa
2835: WHERE
2836: ppa.project_id = pal.project_id
2837: AND ppa.project_asset_id = pal.project_asset_id
2838: AND

Line 2907: pa_project_assets ppa

2903: AND pal.project_asset_id IN
2904: (SELECT
2905: ppa.project_asset_id
2906: FROM
2907: pa_project_assets ppa
2908: WHERE
2909: ppa.project_id = pal.project_id
2910: AND ppa.capitalized_flag = 'Y'
2911: );

Line 2931: pa_project_assets

2927: x_err_code := 0;
2928: x_err_stage := 'Updating the asset status';
2929:
2930: UPDATE
2931: pa_project_assets
2932: SET
2933: capitalized_flag = x_capitalized_flag,
2934: capitalized_date = sysdate,
2935: last_update_date = sysdate,

Line 2966: pa_project_assets

2962:
2963: IF x_adjustment_type = 'R' THEN
2964: --this is a reversing adjustment so do NOT update capitalized_date
2965: UPDATE
2966: pa_project_assets
2967: SET
2968: cost_adjustment_flag = x_adjustment_flag,
2969: last_update_date = sysdate,
2970: last_updated_by = x_last_updated_by,

Line 2981: pa_project_assets

2977: project_asset_id = x_project_asset_id;
2978: ELSE
2979: --this is a non-reversing adjustment. Update capitalized_date
2980: UPDATE
2981: pa_project_assets
2982: SET
2983: cost_adjustment_flag = x_adjustment_flag,
2984: capitalized_date = sysdate,
2985: last_update_date = sysdate,

Line 3033: v_fa_asset_id PA_PROJECT_ASSETS_ALL.fa_asset_id%TYPE;

3029: faassetrec selfaassets%ROWTYPE;
3030: -- Fix for bug : 4878878
3031: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
3032:
3033: v_fa_asset_id PA_PROJECT_ASSETS_ALL.fa_asset_id%TYPE;
3034:
3035:
3036: BEGIN
3037:

Line 3050: FROM pa_project_assets_all

3046: --if the project asset has been Tied Back.
3047:
3048: SELECT fa_asset_id
3049: INTO v_fa_asset_id
3050: FROM pa_project_assets_all
3051: WHERE project_asset_id = x_project_asset_id;
3052:
3053: IF v_fa_asset_id IS NOT NULL THEN
3054:

Line 3157: pa_project_assets ppa

3153: AND exists
3154: (SELECT
3155: 'Yes'
3156: FROM
3157: pa_project_assets ppa
3158: WHERE
3159: ppa.project_asset_id = pal.project_asset_id
3160: AND ppa.capitalized_flag = 'N'
3161: AND ppa.reverse_flag||'' = 'N'

Line 3703: pa_project_assets ppa,

3699: ppa.serial_number,
3700: ppa.tag_number
3701: FROM
3702: pa_project_asset_lines pal,
3703: pa_project_assets ppa,
3704: pa_projects pp,
3705: pa_project_types ppt
3706: WHERE
3707: pal.project_asset_id = ppa.project_asset_id

Line 4474: from pa_project_assets ppa

4470: where pal.project_id = ppr.project_id
4471: and pal.rev_proj_asset_line_id IS NULL -- This line is not an adjustment
4472: and pal.transfer_status_code <> 'T')
4473: or exists ( select 'x' -- project has assets to be reverse capitalized
4474: from pa_project_assets ppa
4475: where ppa.project_id+0 = ppr.project_id
4476: and ppa.reverse_flag = 'Y'));
4477: */
4478:

Line 4557: pa_project_assets table since the client code has not been fired at this point.

4553: --with a Capital Event Processing method of 'None'. This logic is not executed
4554: --when run for a specific Event.
4555: /*bug 5642019 - this piece of code moved inside projrec loop.In case when PA_CLIENT_EXTN_ASSET_CREATION
4556: is used to create project assets procedure no_event_projects will fail to update
4557: pa_project_assets table since the client code has not been fired at this point.
4558: IF x_capital_event_id IS NULL THEN
4559:
4560: PA_FAXFACE.NO_EVENT_PROJECTS
4561: ( x_project_num_from => x_project_num_from,

Line 5006: pa_project_assets ppa

5002: pal.transfer_status_code||'' IN ('P','R')
5003: and (exists
5004: (SELECT 'x'
5005: FROM
5006: pa_project_assets ppa
5007: WHERE ppa.project_id = ppr.project_id
5008: AND ppa.reverse_flag||'' = 'N'
5009: AND TRUNC(ppa.date_placed_in_service) <=
5010: TRUNC(NVL(x_in_service_date_through,ppa.date_placed_in_service))

Line 5017: pa_project_assets ppa

5013: )
5014: or exists
5015: (SELECT 'x'
5016: FROM
5017: pa_project_assets ppa
5018: WHERE ppa.project_id = ppr.project_id
5019: AND ppa.reverse_flag||'' = 'N'
5020: AND ppa.capitalized_flag ='Y'
5021: AND TRUNC(ppa.date_placed_in_service) <=

Line 5029: pa_project_assets ppa

5025: )
5026: or exists
5027: (SELECT 'x'
5028: FROM
5029: pa_project_assets ppa
5030: WHERE ppa.project_id = ppr.project_id
5031: AND ppa.capitalized_flag = 'Y'
5032: AND pal.rev_proj_asset_line_id is not null
5033: AND pal.project_asset_id = ppa.project_asset_id

Line 5403: FROM pa_project_assets ppa

5399: WHERE pal.project_id = p_project_id
5400: AND pal.rev_proj_asset_line_id IS NULL -- This line is not an adjustment
5401: AND pal.transfer_status_code <> 'T')
5402: OR EXISTS (SELECT 'x' -- project has assets to be reverse capitalized
5403: FROM pa_project_assets ppa
5404: WHERE ppa.project_id+0 = p_project_id
5405: AND ppa.reverse_flag = 'Y');
5406: RETURN TRUE;
5407:

Line 5421: FROM pa_project_assets ppa

5417:
5418: SELECT 1 INTO dummy
5419: FROM DUAL
5420: WHERE EXISTS (SELECT 'x' -- project has assets to be reverse capitalized
5421: FROM pa_project_assets ppa
5422: WHERE ppa.project_id+0 = p_project_id
5423: AND ppa.reverse_flag = 'Y'
5424: /* Automatic asset capitalization changes JPULTORAK 04-FEB-03 */
5425: AND capital_event_id = NVL(p_capital_event_id, capital_event_id)

Line 5659: UPDATE pa_project_assets

5655:
5656: --If CCID value has changed, update Project Asset row
5657: IF NVL(x_out_deprn_expense_ccid,-999) <> NVL(x_in_deprn_expense_ccid,-999) THEN
5658:
5659: UPDATE pa_project_assets
5660: SET depreciation_expense_ccid = x_out_deprn_expense_ccid,
5661: last_update_date = SYSDATE,
5662: last_updated_by = x_last_updated_by,
5663: last_update_login = x_last_update_login,

Line 5719: pa_project_assets ppa,

5715: pal.current_asset_cost,
5716: pal.gl_date
5717: FROM
5718: pa_project_asset_lines pal,
5719: pa_project_assets ppa,
5720: pa_projects pp,
5721: pa_project_types ppt
5722: WHERE
5723: pal.project_asset_id = ppa.project_asset_id

Line 6030: UPDATE pa_project_assets_all

6026:
6027: IF is_no_event_proj = 'Y' then
6028:
6029: --Update all project assets that have a DPIS (AS-BUILT or RETIREMENT_ADJUSTMENT)
6030: UPDATE pa_project_assets_all
6031: SET capital_event_id = -1,
6032: last_update_date = SYSDATE,
6033: last_updated_by = x_last_updated_by,
6034: last_update_login = x_last_update_login,