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 922: , pa_agreements_all agr

918: FROM
919: -- ra_customers ra
920: hz_parties party
921: , hz_cust_accounts cust_acct
922: , pa_agreements_all agr
923: , pa_project_customers pc
924: , pa_summary_project_fundings spf
925: -- WHERE ra.customer_id = agr.customer_id
926: WHERE cust_acct.cust_account_id= agr.customer_id

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 1137: , pa_agreements_all agr

1133: FROM
1134: -- ra_customers ra
1135: hz_parties party
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

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