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

Line 264: pa_draft_invoice_items dii

260: INTO
261: l_projfunc_inv_due_unaccepted,
262: l_proj_inv_due_unaccepted
263: FROM pa_draft_invoices_all di,
264: pa_draft_invoice_items dii
265: WHERE dii.project_id = di.project_id
266: AND dii.draft_invoice_num = di.draft_invoice_num
267: AND di.transfer_status_code <> 'A'
268: AND di.project_id = p_project_id

Line 337: pa_draft_invoice_items dii

333: di.system_reference system_reference,
334: SUM(dii.projfunc_bill_amount) pfc_inv_amt,
335: SUM(dii.project_bill_amount) pc_inv_amt
336: FROM pa_draft_invoices_all di,
337: pa_draft_invoice_items dii
338: WHERE di.project_id = dii.project_id
339: AND di.draft_invoice_num = dii.draft_invoice_num
340: AND di.transfer_status_code = 'A'
341: AND di.system_reference IS NOT NULL

Line 380: pa_draft_invoice_items dii ,

376: Nvl(SUM(arps.amount_line_items_remaining),1)line_amt_remn,
377: Nvl(SUM(arps.tax_original),0) tax_orig,
378: Nvl(SUM(arps.tax_remaining),0) tax_remn
379: FROM pa_draft_invoices_all di,
380: pa_draft_invoice_items dii ,
381: ar_payment_schedules_all arps
382: WHERE di.project_id = dii.project_id
383: AND di.draft_invoice_num = dii.draft_invoice_num
384: AND di.transfer_status_code = 'A'

Line 520: FROM pa_draft_invoice_items dii

516: SUM(NVL(dii.projfunc_bill_amount,0)) pfc_total_partial_billed
517: INTO
518: l_pc_total_part_bill_amt,
519: l_pfc_total_part_bill_amt
520: FROM pa_draft_invoice_items dii
521: WHERE dii.project_id = p_project_id
522: AND EXISTS ( SELECT null
523: FROM pa_events eve
524: WHERE eve.event_num = dii.event_num

Line 534: FROM pa_draft_invoice_items dii, pa_events eve

530: SUM(NVL(dii.projfunc_bill_amount,0)) pfc_total_partial_billed
531: INTO
532: l_pc_total_part_bill_amt,
533: l_pfc_total_part_bill_amt
534: FROM pa_draft_invoice_items dii, pa_events eve
535: WHERE eve.project_id = p_project_id
536: and eve.project_id = dii.project_id
537: and nvl(eve.task_id, 0) = nvl(dii.event_task_id,0)
538: and eve.event_num = nvl(dii.event_num,0)

Line 570: FROM pa_draft_invoice_items dii,pa_draft_invoices_all di

566: SUM(NVL(dii.projfunc_bill_amount,0)) unapproved_project_invoice
567: INTO
568: l_proj_unapprov_inv_amt,
569: l_projfunc_unapprov_inv_amt
570: FROM pa_draft_invoice_items dii,pa_draft_invoices_all di
571: WHERE dii.draft_invoice_num = di.draft_invoice_num
572: AND dii.project_id = di.project_id
573: AND di.project_id = p_project_id
574: AND di.approved_by_person_id IS NULL;

Line 945: FROM pa_draft_invoices_all di , pa_draft_invoice_items dii , pa_agreements_all agr

941: SET (pbw.pc_invoiced,pbw.pfc_invoiced ) =
942: (SELECT
943: SUM(NVL(dii.project_bill_amount,0)) projinv_amt
944: ,SUM(NVL(dii.projfunc_bill_amount,0)) projfuncinv_amt
945: FROM pa_draft_invoices_all di , pa_draft_invoice_items dii , pa_agreements_all agr
946: WHERE dii.draft_invoice_num = di.draft_invoice_num
947: AND dii.project_id = di.project_id
948: AND agr.customer_id = di.customer_id
949: AND agr.agreement_id = di.agreement_id

Line 1009: pa_draft_invoice_items dii,

1005: di.system_reference system_reference,
1006: SUM(dii.project_bill_amount) pc_inv_amt,
1007: SUM(dii.projfunc_bill_amount) pfc_inv_amt
1008: FROM pa_draft_invoices_all di,
1009: pa_draft_invoice_items dii,
1010: PA_BILL_WRKBENCH_INV_TEMP pbwi
1011: WHERE di.project_id = dii.project_id
1012: AND di.draft_invoice_num = dii.draft_invoice_num
1013: AND di.transfer_status_code = 'A'

Line 1059: pa_draft_invoice_items dii

1055: ( SELECT
1056: SUM(dii.project_bill_amount) ,
1057: SUM(dii.projfunc_bill_amount)
1058: FROM pa_draft_invoices_all di,
1059: pa_draft_invoice_items dii
1060: WHERE di.project_id = dii.project_id
1061: AND di.draft_invoice_num = dii.draft_invoice_num
1062: AND di.transfer_status_code <> 'A'
1063: AND di.customer_id = pbw.customer_id

Line 1174: FROM pa_draft_invoices_all di , pa_draft_invoice_items dii , pa_agreements_all agr

1170: SET (pbw.pc_invoiced,pbw.pfc_invoiced ) =
1171: (SELECT
1172: SUM(NVL(dii.project_bill_amount,0)) projinv_amt
1173: ,SUM(NVL(dii.projfunc_bill_amount,0)) projfuncinv_amt
1174: FROM pa_draft_invoices_all di , pa_draft_invoice_items dii , pa_agreements_all agr
1175: WHERE dii.draft_invoice_num = di.draft_invoice_num
1176: AND dii.project_id = di.project_id
1177: AND agr.customer_id = di.customer_id
1178: AND agr.agreement_id = di.agreement_id

Line 1245: pa_draft_invoice_items dii,

1241: di.system_reference system_reference,
1242: SUM(dii.project_bill_amount) pc_inv_amt,
1243: SUM(dii.projfunc_bill_amount) pfc_inv_amt
1244: FROM pa_draft_invoices_all di,
1245: pa_draft_invoice_items dii,
1246: PA_BILL_WRKBENCH_INV_TEMP pbwi
1247: WHERE di.project_id = dii.project_id
1248: AND di.draft_invoice_num = dii.draft_invoice_num
1249: AND di.agreement_id = NVL(p_agreement_id,di.agreement_id)

Line 1307: pa_draft_invoice_items dii

1303: ( SELECT
1304: SUM(dii.project_bill_amount) ,
1305: SUM(dii.projfunc_bill_amount)
1306: FROM pa_draft_invoices_all di,
1307: pa_draft_invoice_items dii
1308: WHERE di.project_id = dii.project_id
1309: AND di.draft_invoice_num = dii.draft_invoice_num
1310: AND di.agreement_id = NVL(p_agreement_id,di.agreement_id)
1311: AND di.draft_invoice_num = NVL(p_draft_num,di.draft_invoice_num)