[Home] [Help]
209: where transaction_number = cp_trx_number;
210:
211: r_man_trx_rec c_get_man_trx_rec%rowtype;
212:
213: cursor c_get_vendor_name (cp_vendor_id po_vendors.vendor_id%type)
214: is
215: select vendor_name
216: from po_vendors
217: where vendor_id = cp_vendor_id;
212:
213: cursor c_get_vendor_name (cp_vendor_id po_vendors.vendor_id%type)
214: is
215: select vendor_name
216: from po_vendors
217: where vendor_id = cp_vendor_id;
218:
219: cursor c_get_customer_name (cp_party_id po_vendors.vendor_id%type)
220: is
215: select vendor_name
216: from po_vendors
217: where vendor_id = cp_vendor_id;
218:
219: cursor c_get_customer_name (cp_party_id po_vendors.vendor_id%type)
220: is
221: select hzp.party_name
222: from hz_cust_accounts hzca
223: ,hz_parties hzp
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
252: where invoice_id=cp_invoice_id
253: and pv.vendor_id=jrtr.party_id
254: and rownum=1;
255:
783: from po_headers_all poh
784: , po_lines_all pol
785: , po_line_locations_all poll /*6843479*/
786: , mtl_system_items msi
787: , po_vendors pov
788: , hr_locations hl /* Added by vkantamn for Bug#6083978 */
789: -- , financials_system_parameters fsp /* Commented by vkantamn for Bug#6083978 */
790: where
791: --poh.po_header_id = p_document_id /* Commented by vkantamn for Bug#6083978 */
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
861: AND apa.invoice_id = apla.invoice_id
862: AND apla.line_number = p_document_line_id