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_PWP_SUMM_PKG dependencies on PA_DRAFT_INVOICES_ALL

Line 81: FROM PA_DRAFT_INVOICES_ALL I

77: , l_user_id
78: , l_date
79: , l_user_id
80: , l_date
81: FROM PA_DRAFT_INVOICES_ALL I
82: , PA_DRAFT_INVOICES_ALL ORG_INV
83: , PA_CUSTOMERS_V C
84: ,PA_LOOKUPS LK
85: ,PA_AGREEMENTS_ALL A

Line 82: , PA_DRAFT_INVOICES_ALL ORG_INV

78: , l_date
79: , l_user_id
80: , l_date
81: FROM PA_DRAFT_INVOICES_ALL I
82: , PA_DRAFT_INVOICES_ALL ORG_INV
83: , PA_CUSTOMERS_V C
84: ,PA_LOOKUPS LK
85: ,PA_AGREEMENTS_ALL A
86: WHERE I.AGREEMENT_ID = A.AGREEMENT_ID

Line 209: pa_draft_invoices_all pda

205: (SELECT SUM(INV_AMOUNT ) -- bug 8225160
206: ,SUM(PROJFUNC_BILL_AMOUNT)
207: ,SUM(PROJECT_BILL_AMOUNT)
208: FROM pa_draft_invoice_items pdii,
209: pa_draft_invoices_all pda
210: WHERE pwp.project_id = pda.project_id
211: AND pwp.draft_invoice_num = pda.draft_invoice_num
212: AND pda.gl_date between l_start_date AND l_end_date
213: AND pdii.project_id = pwp.project_id