[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.
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,
907: p.segment1
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
932: ,PA_CUSTOMERS_V c
1973: from jai_ar_trxs
1974: where customer_trx_id = cp_customer_trx_id ;
1975:
1976: -- Begin 5876390, 6012570
1977: cursor c_get_jai_pa_details (cp_project_number pa_projects_all.segment1%type
1978: ,cp_draft_inv_num jai_pa_draft_invoice_lines.draft_invoice_num%type
1979: ,cp_line_num jai_pa_draft_invoice_lines.line_num%type
1980: )
1981: is
1981: is
1982: select draft_invoice_id
1983: ,draft_invoice_line_id
1984: from jai_pa_draft_invoice_lines jpdil
1985: ,pa_projects_all ppa
1986: where ppa.segment1 = cp_project_number
1987: and ppa.project_id = jpdil.project_id
1988: and jpdil.draft_invoice_num = cp_draft_inv_num
1989: and jpdil.line_num = cp_line_num;