DBA Data[Home] [Help]

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 902: /*modified the below cusrsor query to select from the tables PA_DRAFT_INVOICES_ALL,

898: and hzca.cust_account_id = nvl(rct.sold_to_customer_id, rct.bill_to_customer_id)
899: and hzca.party_id = hzp.party_id;
900:
901: -- Begin 5876390, 6012570
902: /*modified the below cusrsor query to select from the tables PA_DRAFT_INVOICES_ALL,
903: PA_PROJECTS_ALL instead of pa_draft_invoices_v.*/
904: cursor c_get_pa_details
905: is
906: select c.customer_name party_name,

Line 927: PA_DRAFT_INVOICES_ALL padi,

923: , jpadi.organization_id organization_id
924: , jpadi.location_id location_id
925: , jpadil.service_type_code service_type_code
926: from
927: PA_DRAFT_INVOICES_ALL padi,
928: PA_PROJECTS_ALL p
929: ,pa_draft_invoice_items padil
930: ,jai_pa_draft_invoices jpadi
931: ,jai_pa_draft_invoice_lines jpadil