[Home] [Help]
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
638: where hzca.cust_account_id = cp_party_id
639: and hzp.party_id = hzca.party_id;
640:
641: cursor c_st_transprt_inv_details(cp_invoice_id ap_invoices_all.invoice_id%type)/* Changes by nprashar , Forward porting from bug 7172723*/
666: where invoice_id=cp_invoice_id
667: and pv.vendor_id=jrtr.party_id
668: and rownum=1;
669:
670: lv_party_name hz_parties.party_name%type;
671:
672: rec_st_transprt_inv_details c_st_transprt_inv_details%rowtype;/* Changes by nprashar , Forward porting from bug 7172723 */
673: rec_st_transprt_party_details c_st_transprt_party_details%rowtype;/* Changes by nprashar , Forward porting from bug 7172723 */
674: lv_service_type_code jai_rgm_trx_records.service_type_code%type;
1513: , oel.line_category_code line_category_code
1514: from
1515: oe_order_headers_all oeh
1516: ,oe_order_lines_all oel
1517: ,hz_parties hzp
1518: ,hz_cust_accounts hzca
1519: ,mtl_system_items msi
1520: where (p_document_id is null or p_document_id = '' or oeh.header_id = p_document_id)
1521: and oel.header_id = oeh.header_id
1545: ,jrct.location_id location_id
1546: from ra_customer_trx_all rct
1547: ,ra_customer_trx_lines_all rctl
1548: ,jai_ar_trxs jrct
1549: ,hz_parties hzp
1550: ,hz_cust_accounts hzca
1551: ,mtl_system_items msi
1552: where rct.customer_trx_id = p_document_id
1553: and jrct.customer_trx_id = rct.customer_trx_id
1920: ,jacr.service_type_code service_type_code
1921: ,acra.reversal_date reversal_date --Added by Qiong for bug13555753
1922: from ar_cash_receipts_all acra,
1923: jai_ar_cash_receipts_all jacr,
1924: hz_parties hzp,
1925: hz_cust_accounts hca
1926: WHERE acra.cash_receipt_id = jacr.cash_receipt_id
1927: AND jacr.document_type = 'Service'
1928: AND hca.cust_account_id = jacr.customer_id
1953: /*Added by Qinglei on 05-Jan-2012 for bug#13556198 end*/
1954: from ar_receivable_applications_all araa,
1955: ar_cash_receipts_all acra,
1956: jai_ar_cash_receipts_all jacr,
1957: hz_parties hzp,
1958: hz_cust_accounts hca
1959: WHERE araa.cash_receipt_id = acra.cash_receipt_id
1960: AND acra.cash_receipt_id = jacr.cash_receipt_id
1961: AND jacr.document_type = 'Service'