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_ASSET_LINES

Line 396: pa_project_asset_lines pal

392: WHERE exists
393: (SELECT
394: 'Yes'
395: FROM
396: pa_project_asset_lines pal
397: WHERE
398: pal.project_asset_line_detail_id = x_proj_asset_line_detail_id
399: AND NOT EXISTS
400: ( SELECT

Line 403: pa_project_asset_lines ppal

399: AND NOT EXISTS
400: ( SELECT
401: 'This Line was adjusted before'
402: FROM
403: pa_project_asset_lines ppal
404: WHERE
405: ppal.rev_proj_asset_line_id = pal.project_asset_line_id
406: )
407: AND pal.project_asset_id NOT IN

Line 420: pa_project_asset_lines pal

416: UNION
417: SELECT
418: 'Yes'
419: FROM
420: pa_project_asset_lines pal
421: WHERE
422: pal.project_asset_line_detail_id = x_proj_asset_line_detail_id
423: AND pal.transfer_status_code <> 'T'
424: AND pal.rev_proj_asset_line_id IS NULL

Line 466: pa_project_asset_lines pal

462: WHERE exists
463: (SELECT
464: 'Yes'
465: FROM
466: pa_project_asset_lines pal
467: WHERE
468: pal.project_asset_line_detail_id = x_proj_asset_line_detail_id
469: AND pal.transfer_status_code <> 'P'
470: );

Line 634: SELECT pa_project_asset_lines_s.nextval

630: BEGIN
631: x_err_code := 0;
632: x_err_stage := 'Create Project Asset Line';
633:
634: SELECT pa_project_asset_lines_s.nextval
635: INTO project_asset_line_id
636: FROM sys.dual;
637:
638: INSERT INTO pa_project_asset_lines(

Line 638: INSERT INTO pa_project_asset_lines(

634: SELECT pa_project_asset_lines_s.nextval
635: INTO project_asset_line_id
636: FROM sys.dual;
637:
638: INSERT INTO pa_project_asset_lines(
639: project_asset_line_id,
640: description,
641: project_asset_id,
642: project_id,

Line 757: pa_project_asset_lines pal

753: CURSOR seldetailids IS
754: SELECT
755: pal.project_asset_line_detail_id
756: FROM
757: pa_project_asset_lines pal
758: WHERE
759: pal.project_id+0 = x_project_id
760: AND pal.capital_event_id = NVL(x_capital_event_id, pal.capital_event_id)
761: AND pal.project_asset_id IN

Line 776: pa_project_asset_lines ppal

772: AND NOT EXISTS
773: ( SELECT
774: 'This Line was adjusted before'
775: FROM
776: pa_project_asset_lines ppal
777: WHERE
778: ppal.rev_proj_asset_line_id = pal.project_asset_line_id
779: )
780: GROUP by project_asset_line_detail_id;

Line 820: pa_project_asset_lines pal

816: ,line_type
817: ,capital_event_id
818: ,retirement_cost_type
819: FROM
820: pa_project_asset_lines pal
821: WHERE
822: pal.project_id+0 = x_project_id
823: AND pal.rev_proj_asset_line_id is NULL /* Added this for the bug 3989536 */
824: AND pal.capital_event_id = NVL(x_capital_event_id, pal.capital_event_id)

Line 840: pa_project_asset_lines ppal

836: AND NOT EXISTS
837: ( SELECT
838: 'This Line was adjusted before'
839: FROM
840: pa_project_asset_lines ppal
841: WHERE
842: ppal.rev_proj_asset_line_id = pal.project_asset_line_id
843: );
844:

Line 1147: pa_project_asset_lines

1143: x_err_code := 0;
1144: x_err_stage := 'Deleting the project asset line';
1145:
1146: DELETE
1147: pa_project_asset_lines
1148: WHERE
1149: project_asset_line_id = x_project_asset_line_id;
1150:
1151: IF l_mrc_flag = 'Y' THEN

Line 1208: pa_project_asset_lines ppal

1204: ppal.project_asset_line_id,
1205: ppal.project_asset_id,
1206: ppal.current_asset_cost
1207: FROM
1208: pa_project_asset_lines ppal
1209: WHERE
1210: ppal.rev_proj_asset_line_id IS NULL
1211: AND ppal.transfer_status_code <> 'T'
1212: AND ppal.capital_event_id = NVL(x_capital_event_id, ppal.capital_event_id)

Line 1215: /+ INDEX (pal PA_PROJECT_ASSET_LINES_N2) /pal.project_asset_line_detail_id

1211: AND ppal.transfer_status_code <> 'T'
1212: AND ppal.capital_event_id = NVL(x_capital_event_id, ppal.capital_event_id)
1213: AND ppal.project_asset_line_detail_id IN
1214: (SELECT
1215: /*+ INDEX (pal PA_PROJECT_ASSET_LINES_N2) */pal.project_asset_line_detail_id
1216: FROM
1217: pa_project_asset_lines pal
1218: WHERE
1219: pal.project_id = x_project_id

Line 1217: pa_project_asset_lines pal

1213: AND ppal.project_asset_line_detail_id IN
1214: (SELECT
1215: /*+ INDEX (pal PA_PROJECT_ASSET_LINES_N2) */pal.project_asset_line_detail_id
1216: FROM
1217: pa_project_asset_lines pal
1218: WHERE
1219: pal.project_id = x_project_id
1220: AND pal.rev_proj_asset_line_id IS NULL -- This line is not an adjustment
1221: AND pal.transfer_status_code <> 'T'

Line 1893: description pa_project_asset_lines.description%TYPE;

1889: prev_asset_category_id NUMBER;
1890: curr_asset_cost NUMBER;
1891: prev_asset_cost NUMBER;
1892: proj_asset_line_detail_id NUMBER;
1893: description pa_project_asset_lines.description%TYPE;
1894: depreciation_expense_ccid NUMBER;
1895: prev_sys_link_fun pa_expenditure_items_all.system_linkage_function%TYPE;
1896:
1897: curr_employee_id po_vendors.employee_id%type;

Line 1926: v_retirement_cost_type pa_project_asset_lines_all.retirement_cost_type%TYPE := NULL;

1922: prev_inv_line_number ap_invoice_distributions.invoice_line_number%TYPE;
1923:
1924: curr_capital_event_id pa_capital_events.capital_event_id%TYPE;
1925: prev_capital_event_id pa_capital_events.capital_event_id%TYPE;
1926: v_retirement_cost_type pa_project_asset_lines_all.retirement_cost_type%TYPE := NULL;
1927: extn_capital_event_id pa_capital_events.capital_event_id%TYPE;
1928: extn_capital_hold_flag pa_project_assets_all.capital_hold_flag%TYPE;
1929: extn_project_asset_type pa_project_assets_all.project_asset_type%TYPE;
1930:

Line 2491: pa_project_asset_lines pal

2487: x_err_code := 0;
2488: x_err_stage := 'Marking project asset lines for transfer';
2489:
2490: UPDATE
2491: pa_project_asset_lines pal
2492: SET
2493: pal.transfer_status_code = 'X'
2494: WHERE
2495: pal.transfer_status_code||'' IN ('P','R')

Line 2562: pa_project_asset_lines pal

2558: x_err_code := 0;
2559: x_err_stage := 'Marking reversing lines ';
2560:
2561: UPDATE
2562: pa_project_asset_lines pal
2563: SET
2564: pal.transfer_status_code = 'X'
2565: WHERE pal.transfer_status_code||'' IN ('P','R')
2566: AND rev_proj_asset_line_id is not null

Line 2688: pa_project_asset_lines pal

2684: SELECT
2685: fai.asset_id
2686: FROM
2687: fa_asset_invoices fai,
2688: pa_project_asset_lines pal
2689: WHERE
2690: fai.project_asset_line_id = pal.project_asset_line_id
2691: AND pal.project_asset_id = x_project_asset_id
2692: AND pal.transfer_status_code||'' = 'T'

Line 2807: pa_project_asset_lines pal

2803:
2804: -- Update project asset lines belonging to new assets
2805:
2806: UPDATE
2807: pa_project_asset_lines pal
2808: SET
2809: pal.transfer_status_code = 'R',
2810: pal.transfer_rejection_reason = 'FUTURE_DPIS',
2811: pal.last_updated_by = x_last_updated_by,

Line 2853: pa_project_asset_lines

2849: x_err_code := 0;
2850: x_err_stage := 'Updating the project asset line';
2851:
2852: UPDATE
2853: pa_project_asset_lines
2854: SET
2855: transfer_rejection_reason = x_transfer_rejection_reason,
2856: transfer_status_code = x_transfer_status_code,
2857: amortize_flag = x_amortize_flag,

Line 3334: pa_project_asset_lines pal,

3330: ppa.model_number,
3331: ppa.serial_number,
3332: ppa.tag_number
3333: FROM
3334: pa_project_asset_lines pal,
3335: pa_project_assets ppa,
3336: pa_projects pp,
3337: pa_project_types ppt
3338: WHERE

Line 3408: merged_cost pa_project_asset_lines.current_asset_cost%type;

3404: posting_status fa_mass_additions.posting_status%TYPE;
3405: queue_name fa_mass_additions.queue_name%TYPE;
3406: create_merged_line BOOLEAN;
3407: merge_code VARCHAR2(2);
3408: merged_cost pa_project_asset_lines.current_asset_cost%type;
3409: req_flag varchar2(1);
3410: keynumber fa_system_controls.asset_key_flex_structure%type;
3411:
3412: l_amortize_flag varchar2(10); -- bug 4508689

Line 4085: from pa_project_asset_lines pal

4081: and pcdl.billable_flag = 'Y'
4082: and pei.task_id = pat.task_id
4083: and pat.project_id = ppr.project_id)
4084: or exists (select 'x' -- Untransferred asset lines exist
4085: from pa_project_asset_lines pal
4086: where pal.project_id = ppr.project_id
4087: and pal.rev_proj_asset_line_id IS NULL -- This line is not an adjustment
4088: and pal.transfer_status_code <> 'T')
4089: or exists ( select 'x' -- project has assets to be reverse capitalized

Line 4111: FROM pa_project_asset_lines_all pal,

4107: pce.capital_event_number,
4108: pce.event_name,
4109: NVL(pce.asset_allocation_method, NVL(p.asset_allocation_method,'N')) asset_allocation_method,
4110: pal.asset_category_id /* Added for bug#3211946 */
4111: FROM pa_project_asset_lines_all pal,
4112: pa_projects p,
4113: pa_capital_events pce
4114: WHERE pal.project_id = p.project_id
4115: AND p.project_id = x_project_id

Line 4606: pa_project_asset_lines pal

4602: ppr.segment1
4603: FROM
4604: pa_projects ppr,
4605: pa_project_types pt,
4606: pa_project_asset_lines pal
4607: WHERE
4608: ppr.segment1 between x_project_num_from and x_project_num_to and
4609: ppr.template_flag <> 'Y' and
4610: PA_PROJECT_UTILS.Check_prj_stus_action_allowed(ppr.project_status_code,

Line 5012: FROM pa_project_asset_lines pal

5008: AND pei.task_id = pat.task_id
5009: AND pat.project_id = p_project_id)
5010:
5011: OR EXISTS (SELECT 'x' -- Untransferred assetlines exist
5012: FROM pa_project_asset_lines pal
5013: WHERE pal.project_id = p_project_id
5014: AND pal.rev_proj_asset_line_id IS NULL -- This line is not an adjustment
5015: AND pal.transfer_status_code <> 'T')
5016: OR EXISTS (SELECT 'x' -- project has assets to be reverse capitalized

Line 5057: FROM pa_project_asset_lines pal

5053:
5054: SELECT 1 INTO dummy
5055: FROM DUAL
5056: WHERE EXISTS (SELECT 'x' -- Untransferred assetlines exist
5057: FROM pa_project_asset_lines pal
5058: WHERE pal.project_id = p_project_id
5059: AND pal.rev_proj_asset_line_id IS NULL -- This line is not an adjustment
5060: AND pal.transfer_status_code <> 'T'
5061: /* Automatic asset capitalization changes JPULTORAK 04-FEB-03 */

Line 5332: pa_project_asset_lines pal,

5328: pal.task_id,
5329: pal.current_asset_cost,
5330: pal.gl_date
5331: FROM
5332: pa_project_asset_lines pal,
5333: pa_project_assets ppa,
5334: pa_projects pp,
5335: pa_project_types ppt
5336: WHERE