[Home] [Help]
327: l_match_postal_code
328: FROM hz_cust_acct_sites acct_site,
329: hz_party_sites party_site,
330: hz_locations loc,
331: hz_cust_site_uses su
332: WHERE acct_site.cust_acct_site_id = su.cust_acct_site_id
333: AND su.site_use_id = p_match_site_use_id
334: AND acct_site.party_site_id = party_site.party_site_id
335: AND loc.location_id = party_site.location_id;
471: ra_customer_trx.trx_date%type,
472: p_customer_id IN
473: ra_customer_trx.customer_trx_id%type,
474: p_site_use_id IN
475: hz_cust_site_uses.site_use_id%type,
476: p_currency_code IN
477: fnd_currencies.currency_code%type,
478: p_payment_method_name OUT NOCOPY
479: ar_receipt_methods.name%type,
707: ra_customer_trx.trx_date%type,
708: p_customer_id IN
709: ra_customer_trx.customer_trx_id%type,
710: p_site_use_id IN
711: hz_cust_site_uses.site_use_id%type,
712: p_currency_code IN
713: fnd_currencies.currency_code%type,
714: p_customer_bank_account_id OUT NOCOPY
715: ce_bank_accounts.bank_account_id%type,
786: fnd_currencies.currency_code%type,
787: p_paying_customer_id IN
788: hz_cust_accounts.cust_account_id%type,
789: p_paying_site_use_id IN
790: hz_cust_site_uses.site_use_id%type,
791: p_bill_to_customer_id IN
792: hz_cust_accounts.cust_account_id%type,
793: p_bill_to_site_use_id IN
794: hz_cust_site_uses.site_use_id%type,
790: hz_cust_site_uses.site_use_id%type,
791: p_bill_to_customer_id IN
792: hz_cust_accounts.cust_account_id%type,
793: p_bill_to_site_use_id IN
794: hz_cust_site_uses.site_use_id%type,
795: p_payment_method_name OUT NOCOPY
796: ar_receipt_methods.name%type,
797: p_receipt_method_id OUT NOCOPY
798: ar_receipt_methods.receipt_method_id%type,
994: fnd_currencies.currency_code%type,
995: p_paying_customer_id IN
996: hz_cust_accounts.cust_account_id%type,
997: p_paying_site_use_id IN
998: hz_cust_site_uses.site_use_id%type,
999: p_bill_to_customer_id IN
1000: hz_cust_accounts.cust_account_id%type,
1001: p_bill_to_site_use_id IN
1002: hz_cust_site_uses.site_use_id%type,
998: hz_cust_site_uses.site_use_id%type,
999: p_bill_to_customer_id IN
1000: hz_cust_accounts.cust_account_id%type,
1001: p_bill_to_site_use_id IN
1002: hz_cust_site_uses.site_use_id%type,
1003: p_payment_type_code IN
1004: ar_receipt_methods.payment_type_code%type,
1005: p_customer_bank_account_id OUT NOCOPY
1006: ce_bank_accounts.bank_account_id%type,
1241: fnd_currencies.currency_code%type,
1242: p_paying_customer_id IN
1243: hz_cust_accounts.cust_account_id%type,
1244: p_paying_site_use_id IN
1245: hz_cust_site_uses.site_use_id%type,
1246: p_bill_to_customer_id IN
1247: hz_cust_accounts.cust_account_id%type,
1248: p_bill_to_site_use_id IN
1249: hz_cust_site_uses.site_use_id%type,
1245: hz_cust_site_uses.site_use_id%type,
1246: p_bill_to_customer_id IN
1247: hz_cust_accounts.cust_account_id%type,
1248: p_bill_to_site_use_id IN
1249: hz_cust_site_uses.site_use_id%type,
1250: p_payment_type_code IN
1251: ar_receipt_methods.payment_type_code%type,
1252: p_payment_method_name OUT NOCOPY
1253: ar_receipt_methods.name%type,
1508: p_term_id IN ra_terms.term_id%type,
1509: p_type_term_id IN ra_terms.term_id%type,
1510: p_type_term_name IN ra_terms.name%type,
1511: p_customer_id IN hz_cust_accounts.cust_account_id%type,
1512: p_site_use_id IN hz_cust_site_uses.site_use_id%type,
1513: p_trx_date IN ra_customer_trx.trx_date%type,
1514: p_class IN ra_cust_trx_types.type%type,
1515: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
1516: p_default_term_id OUT NOCOPY ra_terms.term_id%type,
1625: ra_terms t_cp2,
1626: ra_terms_lines tl,
1627: hz_customer_profiles cp1,
1628: hz_customer_profiles cp2,
1629: hz_cust_site_uses su
1630: WHERE p_customer_id = cp1.cust_account_id(+)
1631: AND su.site_use_id = p_site_use_id
1632: AND cp2.cust_account_id = p_customer_id
1633: AND su.site_use_id = cp1.site_use_id(+)