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 dependencies on PA_DRAFT_INVOICE_ITEMS

Line 801: from pa_draft_invoice_items dii, pa_draft_invoices di

797: DELETE FROM PA_EVENTS V
798: WHERE V.Project_ID = X_project_id
799: AND (nvl(V.Task_ID, -1), V.Event_Num) IN
800: (select nvl(dii.Event_Task_ID, -1), dii.Event_Num
801: from pa_draft_invoice_items dii, pa_draft_invoices di
802: where di.Project_ID = X_project_id
803: and di.draft_invoice_num = X_rev_inv_num
804: and dii.Project_ID = di.Project_ID
805: and dii.draft_invoice_num = di.draft_invoice_num

Line 1017: FROM pa_draft_invoice_items dii,

1013: /* END fix bug 2249216 */
1014: AND pf.project_id = l_project_id
1015: AND NOT EXISTS
1016: ( SELECT null
1017: FROM pa_draft_invoice_items dii,
1018: pa_draft_invoices di
1019: WHERE dii.project_id = di.project_id
1020: AND dii.draft_invoice_num = di.draft_invoice_num
1021: AND ( nvl(pf.task_id,0) = 0

Line 1037: FROM pa_draft_invoice_items dii,

1033: sum(dii.amount) dii_amount,dii.invproc_currency_code,
1034: sum(dii.projfunc_bill_amount) dii_projfunc_amount,dii.projfunc_currency_code,
1035: sum(dii.project_bill_amount) dii_project_amount,dii.project_currency_code,
1036: sum(dii.funding_bill_amount) dii_funding_amount,dii.funding_currency_code
1037: FROM pa_draft_invoice_items dii,
1038: pa_draft_invoices di,
1039: pa_summary_project_fundings pf
1040: WHERE dii.project_id = di.project_id
1041: AND dii.draft_invoice_num = di.draft_invoice_num

Line 1070: FROM pa_draft_invoice_items dii,

1066: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.project_bill_amount * (1 -
1067: ( nvl(di.retention_percentage,0)/100 )) ),dii.project_currency_code) dii_project_amount,dii.project_currency_code,
1068: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.funding_bill_amount * (1 -
1069: ( nvl(di.retention_percentage,0)/100 )) ),dii.funding_currency_code) dii_funding_amount,dii.funding_currency_code
1070: FROM pa_draft_invoice_items dii,
1071: pa_draft_invoices di,
1072: pa_summary_project_fundings pf
1073: WHERE dii.project_id = di.project_id /* Bug#5081194 : Removed the +0 for perf issue */
1074: AND dii.draft_invoice_num+0 = di.draft_invoice_num