DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on HZ_PARTIES

Line 223: ,hz_parties hzp

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
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*/

Line 256: lv_party_name hz_parties.party_name%type;

252: where invoice_id=cp_invoice_id
253: and pv.vendor_id=jrtr.party_id
254: and rownum=1;
255:
256: lv_party_name hz_parties.party_name%type;
257:
258: rec_st_transprt_inv_details c_st_transprt_inv_details%rowtype;/* Changes by nprashar , for bug 7172723 */
259: rec_st_transprt_party_details c_st_transprt_party_details%rowtype;/* Changes by nprashar , for bug bug 7172723 */
260: lv_service_type_code jai_rgm_trx_records.service_type_code%type;

Line 825: ,hz_parties hzp

821: , oel.line_category_code line_category_code
822: from
823: oe_order_headers_all oeh
824: ,oe_order_lines_all oel
825: ,hz_parties hzp
826: ,hz_cust_accounts hzca
827: ,mtl_system_items msi
828: where (p_document_id is null or p_document_id = '' or oeh.header_id = p_document_id)
829: and oel.header_id = oeh.header_id

Line 889: ,hz_parties hzp

885: ,jrct.location_id location_id
886: from ra_customer_trx_all rct
887: ,ra_customer_trx_lines_all rctl
888: ,jai_ar_trxs jrct
889: ,hz_parties hzp
890: ,hz_cust_accounts hzca
891: ,mtl_system_items msi
892: where rct.customer_trx_id = p_document_id
893: and jrct.customer_trx_id = rct.customer_trx_id