View: JAI_CMN_CUSTOMER_DTLS_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_CMN_CUSTOMER_DTLS_V

View Text

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

Columns