[Home] [Help]
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
638: where hzca.cust_account_id = cp_party_id
639: and hzp.party_id = hzca.party_id;
640:
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
1522: and oel.line_id = p_document_line_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
1554: and rctl.customer_trx_id = rct.customer_trx_id
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
1929: AND hzp.party_id = hca.party_id
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'
1962: AND hca.cust_account_id = jacr.customer_id