View: JAI_CMN_CUST_ADDRESS_V

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

View Text

SELECT HZ_CUST.CUST_ACCT_SITE_ID ID
, HZ_LOC.ADDRESS1 ADDRESS1
, /* ADDED FOR EBIZ-00191
, BRATHOD*/ HZ_LOC.ADDRESS2 ADDRESS2
, /* ADDED FOR EBIZ-00191
, BRATHOD*/ HZ_LOC.ADDRESS3 ADDRESS3
, /* ADDED FOR EBIZ-00191
, BRATHOD*/ A.CUSTOMER_ID
, 'CUSTOMER' ATTRIBUTE1
, TO_NUMBER(NULL) ORGANIZATION_ID
, HZ_CUST.ORG_ID OPERATING_UNIT
FROM HZ_LOCATIONS HZ_LOC
, HZ_PARTY_SITES HZ_PSITES
, HZ_CUST_ACCT_SITES_ALL HZ_CUST
, JAI_CMN_CUS_ADDRESSES A
WHERE HZ_CUST.PARTY_SITE_ID = HZ_PSITES.PARTY_SITE_ID
AND HZ_LOC.LOCATION_ID = HZ_PSITES.LOCATION_ID
AND HZ_CUST.CUST_ACCT_SITE_ID = A.ADDRESS_ID /*BUG 7685003 - JOIN CUSTOMER_ID OF JA_IN_CUSTOMER_ADDRESSES WITH CUST_ACCOUNT_ID*/
AND A.CUSTOMER_ID = HZ_CUST.CUST_ACCOUNT_ID UNION ALL /* COMMENTED UNION FOR EBIZ-00190
, BRATHOD */ SELECT B.LOCATION_ID ID
, /*((SUBSTR(B.ADDRESS_LINE_1
, 1
, 30))||(SUBSTR(B.ADDRESS_LINE_2
, 1
, 20)) ||(SUBSTR(B.ADDRESS_LINE_3
, 1
, 10))) ADDRESS
, COMMENTED FOR EBIZ-00191
, BRATHOD*/ B.ADDRESS_LINE_1 ADDRESS1
, /* ADDED FOR EBIZ-00191
, BRATHOD */ B.ADDRESS_LINE_2 ADDRESS2
, /* ADDED FOR EBIZ-00191
, BRATHOD */ B.ADDRESS_LINE_3 ADDRESS3
, /* ADDED FOR EBIZ-00191
, BRATHOD */ TO_NUMBER(NULL)
, 'ORGANIZATION' ATTRIBUTE1
, B1.ORGANIZATION_ID
, TO_NUMBER(NULL) OPERATING_UNIT
FROM HR_LOCATIONS B
, JAI_CMN_INVENTORY_ORGS B1
WHERE B.LOCATION_ID = B1.LOCATION_ID

Columns