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.JAI_TRX_REPO_EXTRACT_PKG dependencies on PA_DRAFT_INVOICES_ALL

Line 18: 4. 23-Aug-2007 Bgowrava 6012570 120.6 modified the c_get_pa_details cursor query to select from the tables PA_DRAFT_INVOICES_ALL,

14: 3. 06-Jul-2007 brathod 6012570 120.4 Enhanced the logic to suppor PROJECT DRAFT INVOICES
15: changes are marked with bug number 5876390 or 6012570
16: R12 Fwd Porting Bug: 6012570
17:
18: 4. 23-Aug-2007 Bgowrava 6012570 120.6 modified the c_get_pa_details cursor query to select from the tables PA_DRAFT_INVOICES_ALL,
19: PA_PROJECTS_ALL instead of pa_draft_invoices_v. This was done to improve the performance
20: of the query
21:
22: 5. 24-Sep-2007 vkantamn 6083978 120.8 The org_id for the po has been changed to fetch from the

Line 1562: /*modified the below cusrsor query to select from the tables PA_DRAFT_INVOICES_ALL,

1558: and hzca.cust_account_id = nvl(rct.sold_to_customer_id, rct.bill_to_customer_id)
1559: and hzca.party_id = hzp.party_id;
1560:
1561: -- Begin 5876390, 6012570
1562: /*modified the below cusrsor query to select from the tables PA_DRAFT_INVOICES_ALL,
1563: PA_PROJECTS_ALL instead of pa_draft_invoices_v.*/
1564: cursor c_get_pa_details
1565: is
1566: select c.customer_name party_name,

Line 1595: PA_DRAFT_INVOICES_ALL padi,

1591: , jpadi.organization_id organization_id
1592: , jpadi.location_id location_id
1593: , jpadil.service_type_code service_type_code
1594: from
1595: PA_DRAFT_INVOICES_ALL padi,
1596: PA_PROJECTS_ALL p
1597: -- ,pa_draft_invoice_items padil Removed by Jia for FP Bug#6691866
1598: ,jai_pa_draft_invoices jpadi
1599: ,jai_pa_draft_invoice_lines jpadil