[Home] [Help]
223: ,hz_parties hzp
224: where hzca.cust_account_id = cp_party_id
225: and hzp.party_id = hzca.party_id;
226:
227: cursor c_st_transprt_inv_details(cp_invoice_id ap_invoices_all.invoice_id%type)/* Changes by nprashar for bug 7172723*/
228: is
229: select
230: aia.invoice_num,
231: substr(aia.invoice_num,instr(aia.invoice_num,'/',1,1)+1,instr(aia.invoice_num,'/',1,2)-instr(aia.invoice_num,'/',1,1)-1) rcp_no,
234: from
235: po_headers_all pha,
236: rcv_transactions rt,
237: rcv_shipment_headers rsh,
238: ap_invoices_all aia
239: where
240: rsh.receipt_num=substr(aia.invoice_num,instr(aia.invoice_num,'/',1,1)+1,instr(aia.invoice_num,'/',1,2)-instr(aia.invoice_num,'/',1,1)-1) AND
241: rsh.shipment_header_id=rt.shipment_header_id AND
242: rt.po_header_id=pha.po_header_id AND
243: pha.org_id=aia.org_id AND
244: aia.invoice_id=cp_invoice_id
245: and rownum=1;
246:
247: cursor c_st_transprt_party_details(cp_invoice_id ap_invoices_all.invoice_id%type) /* Changes by nprashar for bug 7172723*/
248: IS
249: select pv.vendor_name,pv.vendor_id from
250: jai_rgm_trx_refs jrtr,
251: po_vendors pv
852: , apa.vendor_id party_id
853: , jasl.organization_id organization_id
854: , jasl.location_id location_id
855: FROM
856: ap_invoices_all apa
857: , ap_invoice_lines_all apla
858: , po_vendors pov
859: , jai_ap_invoice_lines jasl
860: WHERE apa.invoice_id = p_document_id
1513: /*Addition of code by nprashar for bug # 7172723*/
1514: cursor c_get_source_type
1515: is
1516: select source
1517: from ap_invoices_all aia
1518: where aia.invoice_id in
1519: (select invoice_id
1520: from jai_rgm_Trx_refs refs
1521: where refs.reference_id = p_reference_id);
1596:
1597: ln_doc_id number;
1598: ln_doc_line_id number;
1599: lv_trx_src jai_rgm_trx_records.source%type;
1600: lr_source_type ap_invoices_all.source%type;
1601: lr_doc_details c_get_doc_details%rowtype;
1602:
1603:
1604: begin