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_INVOICES_ALL

Line 263: FROM pa_draft_invoices_all di,

259: SUM(dii.project_bill_amount) pc_inv_amt
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'

Line 292: FROM pa_draft_invoices_all di

288: SELECT 'T' into l_accepted_exist
289: FROM dual
290: WHERE EXISTS
291: (SELECT null
292: FROM pa_draft_invoices_all di
293: WHERE di.project_id = p_project_id
294: AND di.transfer_status_code = 'A'
295: AND di.system_reference IS NOT NULL) ;
296:

Line 336: FROM pa_draft_invoices_all di,

332: di.ra_invoice_number,
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'

Line 379: FROM pa_draft_invoices_all di,

375: Nvl(SUM(arps.amount_line_items_original),1) line_amt_orig,
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

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 1008: FROM pa_draft_invoices_all di,

1004: di.ra_invoice_number,
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

Line 1058: FROM pa_draft_invoices_all di,

1054: SET (pbw.pc_due_pending,pbw.pfc_due_pending ) =
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'

Line 1140: , pa_draft_invoices_all di

1136: , hz_cust_accounts cust_acct
1137: , pa_agreements_all agr
1138: , pa_project_customers pc
1139: , pa_summary_project_fundings spf
1140: , pa_draft_invoices_all di
1141: -- WHERE ra.customer_id = agr.customer_id
1142: WHERE cust_acct.cust_account_id= agr.customer_id
1143: AND cust_acct.party_id = party.party_id
1144: AND di.draft_invoice_num = NVL(p_draft_num,di.draft_invoice_num)

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 1244: FROM pa_draft_invoices_all di,

1240: di.ra_invoice_number,
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

Line 1306: FROM pa_draft_invoices_all di,

1302: SET (pbw.pc_due_pending,pbw.pfc_due_pending ) =
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)