VIEW: APPS.JAI_CMN_CUSTOMER_DTLS_V

Source

View Text - Preformatted

SELECT a.party_name customer_name, b.cust_account_id customer_id , 'Customer' Entity_type FROM hz_parties a, hz_cust_accounts b, (SELECT DISTINCT customer_id FROM JAI_CMN_CUS_ADDRESSES ) c WHERE a.party_id = b.party_id AND b.cust_account_id = c.customer_id UNION ALL /* Commented UNION for EBIZ-00190,BRATHOD */ SELECT HOU.name, HOU.organization_id, 'Organization' Entity_type FROM /* org_organization_definitions */ HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI1, (SELECT DISTINCT organization_id FROM JAI_CMN_INVENTORY_ORGS) c WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID AND HOI1.ORG_INFORMATION1 = 'INV' AND HOI1.ORG_INFORMATION2 = 'Y' AND (HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS' AND HOU.organization_id = c.organization_id

View Text - HTML Formatted

SELECT A.PARTY_NAME CUSTOMER_NAME
, B.CUST_ACCOUNT_ID CUSTOMER_ID
, 'CUSTOMER' ENTITY_TYPE
FROM HZ_PARTIES A
, HZ_CUST_ACCOUNTS B
, (SELECT DISTINCT CUSTOMER_ID
FROM JAI_CMN_CUS_ADDRESSES ) C
WHERE A.PARTY_ID = B.PARTY_ID
AND B.CUST_ACCOUNT_ID = C.CUSTOMER_ID UNION ALL /* COMMENTED UNION FOR EBIZ-00190
, BRATHOD */ SELECT HOU.NAME
, HOU.ORGANIZATION_ID
, 'ORGANIZATION' ENTITY_TYPE
FROM /* ORG_ORGANIZATION_DEFINITIONS */ HR_ORGANIZATION_UNITS HOU
, HR_ORGANIZATION_INFORMATION HOI1
, (SELECT DISTINCT ORGANIZATION_ID
FROM JAI_CMN_INVENTORY_ORGS) C
WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION1 = 'INV'
AND HOI1.ORG_INFORMATION2 = 'Y'
AND (HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS'
AND HOU.ORGANIZATION_ID = C.ORGANIZATION_ID