[Home] [Help]
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
23: PO table.
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,
1567: p.segment1
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
1600: ,PA_CUSTOMERS_V c
3373: from jai_ar_trxs
3374: where customer_trx_id = cp_customer_trx_id ;
3375:
3376: -- Begin 5876390, 6012570
3377: cursor c_get_jai_pa_details (cp_project_number pa_projects_all.segment1%type
3378: ,cp_draft_inv_num jai_pa_draft_invoice_lines.draft_invoice_num%type
3379: ,cp_line_num jai_pa_draft_invoice_lines.line_num%type
3380: )
3381: is
3381: is
3382: select draft_invoice_id
3383: ,draft_invoice_line_id
3384: from jai_pa_draft_invoice_lines jpdil
3385: ,pa_projects_all ppa
3386: where ppa.segment1 = cp_project_number
3387: and ppa.project_id = jpdil.project_id
3388: and jpdil.draft_invoice_num = cp_draft_inv_num
3389: and jpdil.line_num = cp_line_num;