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 423: pa_project_asset_lines pal

419: WHERE exists
420: (SELECT
421: 'Yes'
422: FROM
423: pa_project_asset_lines pal
424: WHERE
425: pal.project_asset_line_detail_id = x_proj_asset_line_detail_id
426: AND NOT EXISTS
427: ( SELECT

Line 430: pa_project_asset_lines ppal

426: AND NOT EXISTS
427: ( SELECT
428: 'This Line was adjusted before'
429: FROM
430: pa_project_asset_lines ppal
431: WHERE
432: ppal.rev_proj_asset_line_id = pal.project_asset_line_id
433: )
434: AND pal.project_asset_id NOT IN

Line 447: pa_project_asset_lines pal

443: UNION
444: SELECT
445: 'Yes'
446: FROM
447: pa_project_asset_lines pal
448: WHERE
449: pal.project_asset_line_detail_id = x_proj_asset_line_detail_id
450: AND pal.transfer_status_code <> 'T'
451: AND pal.rev_proj_asset_line_id IS NULL

Line 493: pa_project_asset_lines pal

489: WHERE exists
490: (SELECT
491: 'Yes'
492: FROM
493: pa_project_asset_lines pal
494: WHERE
495: pal.project_asset_line_detail_id = x_proj_asset_line_detail_id
496: AND pal.transfer_status_code <> 'P'
497: );

Line 665: SELECT pa_project_asset_lines_s.nextval

661: BEGIN
662: x_err_code := 0;
663: x_err_stage := 'Create Project Asset Line';
664:
665: SELECT pa_project_asset_lines_s.nextval
666: INTO project_asset_line_id
667: FROM sys.dual;
668:
669: -- Start: Added as part of the Bug 13256490

Line 693: INSERT INTO pa_project_asset_lines(

689:
690: end if;
691: -- End: Added as part of the Bug 13256490
692:
693: INSERT INTO pa_project_asset_lines(
694: project_asset_line_id,
695: description,
696: project_asset_id,
697: project_id,

Line 815: pa_project_asset_lines pal

811: CURSOR seldetailids IS
812: SELECT
813: pal.project_asset_line_detail_id
814: FROM
815: pa_project_asset_lines pal
816: WHERE
817: pal.project_id+0 = x_project_id
818: AND pal.capital_event_id = NVL(x_capital_event_id, pal.capital_event_id)
819: AND pal.project_asset_id IN

Line 834: pa_project_asset_lines ppal

830: AND NOT EXISTS
831: ( SELECT
832: 'This Line was adjusted before'
833: FROM
834: pa_project_asset_lines ppal
835: WHERE
836: ppal.rev_proj_asset_line_id = pal.project_asset_line_id
837: )
838: GROUP by project_asset_line_detail_id;

Line 878: pa_project_asset_lines pal

874: ,line_type
875: ,capital_event_id
876: ,retirement_cost_type
877: FROM
878: pa_project_asset_lines pal
879: WHERE
880: pal.project_id+0 = x_project_id
881: AND pal.rev_proj_asset_line_id is NULL /* Added this for the bug 3989536 */
882: AND pal.capital_event_id = NVL(x_capital_event_id, pal.capital_event_id)

Line 898: pa_project_asset_lines ppal

894: AND NOT EXISTS
895: ( SELECT
896: 'This Line was adjusted before'
897: FROM
898: pa_project_asset_lines ppal
899: WHERE
900: ppal.rev_proj_asset_line_id = pal.project_asset_line_id
901: );
902:

Line 1205: pa_project_asset_lines

1201: x_err_code := 0;
1202: x_err_stage := 'Deleting the project asset line';
1203:
1204: DELETE
1205: pa_project_asset_lines
1206: WHERE
1207: project_asset_line_id = x_project_asset_line_id;
1208:
1209: IF l_mrc_flag = 'Y' THEN

Line 1237: (select 1 from pa_project_asset_lines_all lines,

1233: set ei.capital_event_id = null
1234: where ei.revenue_distributed_flag = 'N'
1235: and ei.capital_event_id = -1
1236: and EXISTS
1237: (select 1 from pa_project_asset_lines_all lines,
1238: pa_project_asset_line_Details det
1239: where lines.project_id=ei.project_id
1240: and det.expenditure_item_id= ei.expenditure_item_id
1241: and det.REVERSED_FLAG='N'

Line 1286: pa_project_asset_lines ppal

1282: ppal.project_asset_line_id,
1283: ppal.project_asset_id,
1284: ppal.current_asset_cost
1285: FROM
1286: pa_project_asset_lines ppal
1287: WHERE
1288: ppal.rev_proj_asset_line_id IS NULL
1289: AND ppal.transfer_status_code <> 'T'
1290: AND ppal.capital_event_id = NVL(x_capital_event_id, ppal.capital_event_id)

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

1289: AND ppal.transfer_status_code <> 'T'
1290: AND ppal.capital_event_id = NVL(x_capital_event_id, ppal.capital_event_id)
1291: AND ppal.project_asset_line_detail_id IN
1292: (SELECT
1293: /*+ INDEX (pal PA_PROJECT_ASSET_LINES_N2) */pal.project_asset_line_detail_id
1294: FROM
1295: pa_project_asset_lines pal
1296: WHERE
1297: pal.project_id = x_project_id

Line 1295: pa_project_asset_lines pal

1291: AND ppal.project_asset_line_detail_id IN
1292: (SELECT
1293: /*+ INDEX (pal PA_PROJECT_ASSET_LINES_N2) */pal.project_asset_line_detail_id
1294: FROM
1295: pa_project_asset_lines pal
1296: WHERE
1297: pal.project_id = x_project_id
1298: AND pal.rev_proj_asset_line_id IS NULL -- This line is not an adjustment
1299: AND pal.transfer_status_code <> 'T'

Line 2129: description pa_project_asset_lines.description%TYPE;

2125: prev_asset_category_id NUMBER;
2126: curr_asset_cost NUMBER;
2127: prev_asset_cost NUMBER;
2128: proj_asset_line_detail_id NUMBER;
2129: description pa_project_asset_lines.description%TYPE;
2130: depreciation_expense_ccid NUMBER;
2131: prev_sys_link_fun pa_expenditure_items_all.system_linkage_function%TYPE;
2132:
2133: curr_employee_id po_vendors.employee_id%type;

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

2167: prev_inv_line_number ap_invoice_distributions.invoice_line_number%TYPE;
2168:
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:

Line 2824: pa_project_asset_lines pal

2820: x_err_code := 0;
2821: x_err_stage := 'Marking project asset lines for transfer';
2822:
2823: UPDATE
2824: pa_project_asset_lines pal
2825: SET
2826: pal.transfer_status_code = 'X'
2827: WHERE
2828: pal.transfer_status_code||'' IN ('P','R')

Line 2895: pa_project_asset_lines pal

2891: x_err_code := 0;
2892: x_err_stage := 'Marking reversing lines ';
2893:
2894: UPDATE
2895: pa_project_asset_lines pal
2896: SET
2897: pal.transfer_status_code = 'X'
2898: WHERE pal.transfer_status_code||'' IN ('P','R')
2899: AND rev_proj_asset_line_id is not null

Line 3021: pa_project_asset_lines pal

3017: SELECT
3018: fai.asset_id
3019: FROM
3020: fa_asset_invoices fai,
3021: pa_project_asset_lines pal
3022: WHERE
3023: fai.project_asset_line_id = pal.project_asset_line_id
3024: AND pal.project_asset_id = x_project_asset_id
3025: AND pal.transfer_status_code||'' = 'T'

Line 3140: pa_project_asset_lines pal

3136:
3137: -- Update project asset lines belonging to new assets
3138:
3139: UPDATE
3140: pa_project_asset_lines pal
3141: SET
3142: pal.transfer_status_code = 'R',
3143: pal.transfer_rejection_reason = 'FUTURE_DPIS',
3144: pal.last_updated_by = x_last_updated_by,

Line 3186: pa_project_asset_lines

3182: x_err_code := 0;
3183: x_err_stage := 'Updating the project asset line';
3184:
3185: UPDATE
3186: pa_project_asset_lines
3187: SET
3188: transfer_rejection_reason = x_transfer_rejection_reason,
3189: transfer_status_code = x_transfer_status_code,
3190: amortize_flag = x_amortize_flag,

Line 3702: pa_project_asset_lines pal,

3698: ppa.model_number,
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

Line 3776: merged_cost pa_project_asset_lines.current_asset_cost%type;

3772: posting_status fa_mass_additions.posting_status%TYPE;
3773: queue_name fa_mass_additions.queue_name%TYPE;
3774: create_merged_line BOOLEAN;
3775: merge_code VARCHAR2(2);
3776: merged_cost pa_project_asset_lines.current_asset_cost%type;
3777: req_flag varchar2(1);
3778: keynumber fa_system_controls.asset_key_flex_structure%type;
3779:
3780: l_amortize_flag varchar2(10); -- bug 4508689

Line 3782: l_invoice_number pa_project_asset_lines.invoice_number%TYPE;

3778: keynumber fa_system_controls.asset_key_flex_structure%type;
3779:
3780: l_amortize_flag varchar2(10); -- bug 4508689
3781: l_depreciation_expense_ccid NUMBER;
3782: l_invoice_number pa_project_asset_lines.invoice_number%TYPE;
3783: l_invoice_id pa_project_asset_lines.invoice_id%TYPE;
3784: l_vendor_number pa_project_asset_lines.vendor_number%TYPE;
3785: l_po_vendor_id pa_project_asset_lines.po_vendor_id%TYPE;
3786:

Line 3783: l_invoice_id pa_project_asset_lines.invoice_id%TYPE;

3779:
3780: l_amortize_flag varchar2(10); -- bug 4508689
3781: l_depreciation_expense_ccid NUMBER;
3782: l_invoice_number pa_project_asset_lines.invoice_number%TYPE;
3783: l_invoice_id pa_project_asset_lines.invoice_id%TYPE;
3784: l_vendor_number pa_project_asset_lines.vendor_number%TYPE;
3785: l_po_vendor_id pa_project_asset_lines.po_vendor_id%TYPE;
3786:
3787:

Line 3784: l_vendor_number pa_project_asset_lines.vendor_number%TYPE;

3780: l_amortize_flag varchar2(10); -- bug 4508689
3781: l_depreciation_expense_ccid NUMBER;
3782: l_invoice_number pa_project_asset_lines.invoice_number%TYPE;
3783: l_invoice_id pa_project_asset_lines.invoice_id%TYPE;
3784: l_vendor_number pa_project_asset_lines.vendor_number%TYPE;
3785: l_po_vendor_id pa_project_asset_lines.po_vendor_id%TYPE;
3786:
3787:
3788: -- Fix for bug : 4878878

Line 3785: l_po_vendor_id pa_project_asset_lines.po_vendor_id%TYPE;

3781: l_depreciation_expense_ccid NUMBER;
3782: l_invoice_number pa_project_asset_lines.invoice_number%TYPE;
3783: l_invoice_id pa_project_asset_lines.invoice_id%TYPE;
3784: l_vendor_number pa_project_asset_lines.vendor_number%TYPE;
3785: l_po_vendor_id pa_project_asset_lines.po_vendor_id%TYPE;
3786:
3787:
3788: -- Fix for bug : 4878878
3789: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 4469: from pa_project_asset_lines pal

4465: and pcdl.billable_flag = 'Y'
4466: and pei.task_id = pat.task_id
4467: and pat.project_id = ppr.project_id)
4468: or exists (select 'x' -- Untransferred asset lines exist
4469: from pa_project_asset_lines pal
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

Line 4495: FROM pa_project_asset_lines_all pal,

4491: pce.capital_event_number,
4492: pce.event_name,
4493: NVL(pce.asset_allocation_method, NVL(p.asset_allocation_method,'N')) asset_allocation_method,
4494: pal.asset_category_id /* Added for bug#3211946 */
4495: FROM pa_project_asset_lines_all pal,
4496: pa_projects p,
4497: pa_capital_events pce
4498: WHERE pal.project_id = p.project_id
4499: AND p.project_id = x_project_id

Line 4992: pa_project_asset_lines pal

4988: ppr.segment1
4989: FROM
4990: pa_projects ppr,
4991: pa_project_types pt,
4992: pa_project_asset_lines pal
4993: WHERE
4994: ppr.segment1 between x_project_num_from and x_project_num_to and
4995: ppr.template_flag <> 'Y' and
4996: PA_PROJECT_UTILS.Check_prj_stus_action_allowed(ppr.project_status_code,

Line 5398: FROM pa_project_asset_lines pal

5394: AND pei.task_id = pat.task_id
5395: AND pat.project_id = p_project_id)
5396:
5397: OR EXISTS (SELECT 'x' -- Untransferred assetlines exist
5398: FROM pa_project_asset_lines pal
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

Line 5443: FROM pa_project_asset_lines pal

5439:
5440: SELECT 1 INTO dummy
5441: FROM DUAL
5442: WHERE EXISTS (SELECT 'x' -- Untransferred assetlines exist
5443: FROM pa_project_asset_lines pal
5444: WHERE pal.project_id = p_project_id
5445: AND pal.rev_proj_asset_line_id IS NULL -- This line is not an adjustment
5446: AND pal.transfer_status_code <> 'T'
5447: /* Automatic asset capitalization changes JPULTORAK 04-FEB-03 */

Line 5718: pa_project_asset_lines pal,

5714: pal.task_id,
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

Line 6067: FROM PA_PROJECT_ASSET_LINES_ALL LINES,

6063: AND cdl.billable_flag ||''='Y'
6064: AND EXISTS
6065: (
6066: SELECT 1
6067: FROM PA_PROJECT_ASSET_LINES_ALL LINES,
6068: PA_PROJECT_ASSET_LINE_DETAILS DET
6069: WHERE Det.expenditure_item_id = cdl.expenditure_item_id
6070: AND DET.LINE_NUM = CDL.LINE_NUM_REVERSED
6071: AND lines.transfer_status_code = 'T'

Line 6075: FROM pa_project_asset_lines_all lines,

6071: AND lines.transfer_status_code = 'T'
6072: AND det.project_asset_line_detail_id = lines.project_asset_line_detail_id
6073: AND NOT EXISTS
6074: (SELECT NULL
6075: FROM pa_project_asset_lines_all lines,
6076: pa_project_asset_line_details det
6077: WHERE det.expenditure_item_id = cdl.expenditure_item_id
6078: AND det.line_num = cdl.line_num
6079: AND lines.transfer_status_code = 'T'