[Home] [Help]
1839: , x_customer_number
1840: , x_account_description
1841: , x_registry_id
1842: FROM HZ_CUST_ACCOUNTS C
1843: , HZ_PARTIES P
1844: WHERE C.CUST_ACCOUNT_ID = p_sold_to_org_id
1845: AND C.PARTY_ID =P.PARTY_ID;
1846:
1847: ELSE
5596: INTO x_ship_to_customer_name
5597: FROM HZ_CUST_SITE_USES_all site,
5598: HZ_CUST_ACCT_SITES cas,
5599: HZ_CUST_ACCOUNTS cust,
5600: HZ_PARTIES p
5601: WHERE site.cust_acct_site_id=cas.cust_acct_site_id
5602: AND cust.cust_account_id=cas.cust_account_id
5603: AND cust.party_id = p.party_id
5604: AND site.site_use_code=l_site_use_code
5659: INTO x_invoice_to_customer_name
5660: FROM HZ_CUST_SITE_USES_ALL site,
5661: HZ_CUST_ACCT_SITES cas,
5662: HZ_CUST_ACCOUNTS cust,
5663: HZ_PARTIES p
5664: WHERE site.cust_acct_site_id=cas.cust_acct_site_id
5665: AND cust.cust_account_id=cas.cust_account_id
5666: AND cust.party_id = p.party_id
5667: AND site.site_use_code=l_site_use_code
6187: x_phone_line_type,
6188: x_phone_number,
6189: x_email_address
6190: FROM HZ_CONTACT_POINTS CONTACT,
6191: HZ_PARTIES CONTACT_PARTY,
6192: HZ_CUST_ACCOUNT_ROLES ACCT_ROLES,
6193: HZ_CUST_ACCOUNTS CUST_ACCT,
6194: HZ_RELATIONSHIPS PARTY_REL,
6195: HZ_PARTIES REL_PARTY,
6191: HZ_PARTIES CONTACT_PARTY,
6192: HZ_CUST_ACCOUNT_ROLES ACCT_ROLES,
6193: HZ_CUST_ACCOUNTS CUST_ACCT,
6194: HZ_RELATIONSHIPS PARTY_REL,
6195: HZ_PARTIES REL_PARTY,
6196: AR_LOOKUPS ARL
6197: WHERE CONTACT.owner_table_name(+) = 'HZ_PARTIES'
6198: AND CONTACT.PRIMARY_FLAG (+) = 'Y'
6199: AND CONTACT.contact_point_type (+) = 'PHONE'
6193: HZ_CUST_ACCOUNTS CUST_ACCT,
6194: HZ_RELATIONSHIPS PARTY_REL,
6195: HZ_PARTIES REL_PARTY,
6196: AR_LOOKUPS ARL
6197: WHERE CONTACT.owner_table_name(+) = 'HZ_PARTIES'
6198: AND CONTACT.PRIMARY_FLAG (+) = 'Y'
6199: AND CONTACT.contact_point_type (+) = 'PHONE'
6200: AND ACCT_ROLES.PARTY_ID = CONTACT.owner_table_id(+)
6201: AND ACCT_ROLES.cust_account_role_id = p_contact_id