[Home] [Help]
623: where transaction_number = cp_trx_number;
624:
625: r_man_trx_rec c_get_man_trx_rec%rowtype;
626:
627: cursor c_get_vendor_name (cp_vendor_id po_vendors.vendor_id%type)
628: is
629: select vendor_name
630: from po_vendors
631: where vendor_id = cp_vendor_id;
626:
627: cursor c_get_vendor_name (cp_vendor_id po_vendors.vendor_id%type)
628: is
629: select vendor_name
630: from po_vendors
631: where vendor_id = cp_vendor_id;
632:
633: cursor c_get_customer_name (cp_party_id po_vendors.vendor_id%type)
634: is
629: select vendor_name
630: from po_vendors
631: where vendor_id = cp_vendor_id;
632:
633: cursor c_get_customer_name (cp_party_id po_vendors.vendor_id%type)
634: is
635: select hzp.party_name
636: from hz_cust_accounts hzca
637: ,hz_parties hzp
661: cursor c_st_transprt_party_details(cp_invoice_id ap_invoices_all.invoice_id%type) /* Changes by nprashar , Forward porting from bug 7172723*/
662: IS
663: select pv.vendor_name,pv.vendor_id from
664: jai_rgm_trx_refs jrtr,
665: po_vendors pv
666: where invoice_id=cp_invoice_id
667: and pv.vendor_id=jrtr.party_id
668: and rownum=1;
669:
1439: from po_headers_all poh
1440: , po_lines_all pol
1441: , po_line_locations_all poll /*6841116*/
1442: , mtl_system_items msi
1443: , po_vendors pov
1444: , hr_locations hl /* Added by vkantamn for Bug#6083978 */
1445: -- , financials_system_parameters fsp /* Commented by vkantamn for Bug#6083978 */
1446: where
1447: --poh.po_header_id = p_document_id /* Commented by vkantamn for Bug#6083978 */
1479: , rcv_shipment_headers rsh
1480: , rcv_shipment_lines rsl
1481: , po_lines_all pla
1482: , mtl_system_items msi
1483: , po_vendors pov
1484: , hr_locations_all hl
1485: where
1486: rta.transaction_id = cp_transaction_id
1487: and rta.po_line_id = pla.po_line_id
1787: ,jasl.organization_id organization_id
1788: ,jasl.location_id location_id
1789: from ap_invoices_all apa
1790: , ap_invoice_lines_all apla
1791: , po_vendors pov
1792: , jai_ap_invoice_lines jasl
1793: where
1794: apa.invoice_id = p_document_id
1795: and apa.invoice_id = apla.invoice_id
2117: ,NULL organization_id
2118: ,NULL location_id
2119: from ap_invoices_all apa
2120: , ap_invoice_lines_all apla
2121: , po_vendors pov
2122: , ap_invoice_distributions_all aida
2123: where
2124: apa.invoice_id = p_document_id
2125: AND aida.invoice_id = p_document_id