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_BILLING_PUB dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 355: pa_expenditure_items_all ei,

351: 'R', nvl(rdl.amount,0),
352: 'C', nvl(ei.raw_cost,0),
353: 'B', nvl(ei.burden_cost,0), nvl(ei.raw_cost,0)) amt
354: FROM pa_tasks t,
355: pa_expenditure_items_all ei,
356: pa_expenditure_items_all ei2,
357: pa_cust_rev_dist_lines rdl
358: WHERE
359: ei.task_id = t.task_Id

Line 356: pa_expenditure_items_all ei2,

352: 'C', nvl(ei.raw_cost,0),
353: 'B', nvl(ei.burden_cost,0), nvl(ei.raw_cost,0)) amt
354: FROM pa_tasks t,
355: pa_expenditure_items_all ei,
356: pa_expenditure_items_all ei2,
357: pa_cust_rev_dist_lines rdl
358: WHERE
359: ei.task_id = t.task_Id
360: AND (t.top_task_id = X_top_task_id

Line 411: pa_expenditure_items_all ei2,

407: 'R', nvl(rdl.amount,0),
408: 'C', nvl(ei.raw_cost,0),
409: 'B', nvl(ei.burden_cost,0), nvl(ei.raw_cost,0)) amt
410: FROM pa_tasks t,
411: pa_expenditure_items_all ei2,
412: pa_expenditure_items_all ei,
413: pa_cust_rev_dist_lines rdl2,
414: pa_cust_rev_dist_lines rdl,
415: pa_draft_invoice_items pdii,

Line 412: pa_expenditure_items_all ei,

408: 'C', nvl(ei.raw_cost,0),
409: 'B', nvl(ei.burden_cost,0), nvl(ei.raw_cost,0)) amt
410: FROM pa_tasks t,
411: pa_expenditure_items_all ei2,
412: pa_expenditure_items_all ei,
413: pa_cust_rev_dist_lines rdl2,
414: pa_cust_rev_dist_lines rdl,
415: pa_draft_invoice_items pdii,
416: pa_draft_invoices pdi

Line 466: FROM pa_expenditure_items_all ei,

462: decode(X_which_amount, 'C', nvl(ei.raw_cost,0),
463: 'B', nvl(ei.burden_cost,0),
464: nvl(ei.burden_cost,0)) amt,
465: decode(ei.adjusted_expenditure_item_id, NULL, 'N','Y') ei_adj
466: FROM pa_expenditure_items_all ei,
467: /* pa_expenditure_items_all ei2, commented for Bug#2499051*/
468: pa_tasks t
469: WHERE
470: ei.task_id = t.task_Id

Line 467: /* pa_expenditure_items_all ei2, commented for Bug#2499051*/

463: 'B', nvl(ei.burden_cost,0),
464: nvl(ei.burden_cost,0)) amt,
465: decode(ei.adjusted_expenditure_item_id, NULL, 'N','Y') ei_adj
466: FROM pa_expenditure_items_all ei,
467: /* pa_expenditure_items_all ei2, commented for Bug#2499051*/
468: pa_tasks t
469: WHERE
470: ei.task_id = t.task_Id
471: AND (t.top_task_id = X_top_task_id