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_AGREEMENTS_ALL

Line 144: pa_agreements_all agr

140: spf.project_id project_id
141: ,spf.agreement_id
142: ,agr.customer_id customer_id
143: FROM
144: pa_agreements_all agr
145: , pa_summary_project_fundings spf
146: WHERE agr.customer_id = pc.customer_id
147: AND agr.agreement_id = spf.agreement_id
148: AND spf.project_id = pc.project_id

Line 864: , pa_agreements_all agr

860: FROM
861: -- ra_customers ra
862: hz_parties party
863: , hz_cust_accounts cust_acct
864: , pa_agreements_all agr
865: , pa_project_customers pc
866: , pa_summary_project_fundings spf
867: -- WHERE ra.customer_id = agr.customer_id
868: WHERE cust_acct.cust_account_id= agr.customer_id

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

883: SET (pbw.pc_invoiced,pbw.pfc_invoiced ) =
884: (SELECT
885: SUM(NVL(dii.project_bill_amount,0)) projinv_amt
886: ,SUM(NVL(dii.projfunc_bill_amount,0)) projfuncinv_amt
887: FROM pa_draft_invoices_all di , pa_draft_invoice_items dii , pa_agreements_all agr
888: WHERE dii.draft_invoice_num = di.draft_invoice_num
889: AND dii.project_id = di.project_id
890: AND agr.customer_id = di.customer_id
891: AND agr.agreement_id = di.agreement_id

Line 1070: , pa_agreements_all agr

1066: FROM
1067: -- ra_customers ra
1068: hz_parties party
1069: , hz_cust_accounts cust_acct
1070: , pa_agreements_all agr
1071: , pa_project_customers pc
1072: , pa_summary_project_fundings spf
1073: , pa_draft_invoices_all di
1074: -- WHERE ra.customer_id = agr.customer_id

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

1103: SET (pbw.pc_invoiced,pbw.pfc_invoiced ) =
1104: (SELECT
1105: SUM(NVL(dii.project_bill_amount,0)) projinv_amt
1106: ,SUM(NVL(dii.projfunc_bill_amount,0)) projfuncinv_amt
1107: FROM pa_draft_invoices_all di , pa_draft_invoice_items dii , pa_agreements_all agr
1108: WHERE dii.draft_invoice_num = di.draft_invoice_num
1109: AND dii.project_id = di.project_id
1110: AND agr.customer_id = di.customer_id
1111: AND agr.agreement_id = di.agreement_id