DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on HZ_CUST_ACCOUNTS

Line 222: from hz_cust_accounts hzca

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
224: where hzca.cust_account_id = cp_party_id
225: and hzp.party_id = hzca.party_id;
226:

Line 826: ,hz_cust_accounts hzca

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
830: and oel.line_id = p_document_line_id

Line 890: ,hz_cust_accounts hzca

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
894: and rctl.customer_trx_id = rct.customer_trx_id