VIEW: APPS.JAI_CMN_CUST_ADDRESS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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