eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IEX_TAP_ACCOUNTS_V

Source

View Text - Preformatted


SELECT /*+ parallel(ORGPRO) parallel(CNTPNT) parallel(X) use_hash(ORGPRO CNTPNT X) */ X.party_id TRANS_OBJECT_ID, X.party_site_id TRANS_DETAIL_OBJECT_ID, X.party_site_id SQUAL_NUM02, X.party_id SQUAL_NUM04, UPPER(CNTPNT.phone_area_code) SQUAL_CHAR08, UPPER(X.category_code) SQUAL_CHAR09, UPPER(ORGPRO.pref_functional_currency) SQUAL_CURC01, UPPER(X.city) SQUAL_CHAR02, ORGPRO.curr_fy_potential_revenue SQUAL_NUM06, UPPER(X.country) SQUAL_CHAR07, UPPER(X.county) SQUAL_CHAR03, X.party_id SQUAL_NUM01, UPPER(X.party_name_substring) SQUAL_FC01, UPPER(X.party_name) SQUAL_CHAR01, X.employees_total SQUAL_NUM05, UPPER(X.postal_code) SQUAL_CHAR06, UPPER(X.province) SQUAL_CHAR05, X.party_id SQUAL_NUM03, UPPER(X.sic_code_type||': '||X.sic_code) SQUAL_CHAR10, UPPER(X.state) SQUAL_CHAR04, UPPER(X.duns_number_c) SQUAL_CHAR11 from HZ_ORGANIZATION_PROFILES ORGPRO , HZ_CONTACT_POINTS CNTPNT, (select /*+ parallel(PARTY) parallel(SITE) parallel(LOC) use_hash(SITE) use_hash(PARTY) use_hash(LOC) */ SITE.party_site_id party_site_id, Site.party_id party_id, LOC.city city, LOC.country country, LOC.county county, LOC.state state, LOC.province province, LOC.postal_code postal_code, PARTY.employees_total employees_total, PARTY.sic_code_type sic_code_type, PARTY.sic_code sic_code, upper(substr(PARTY.party_name,1,1)) party_name_substring, upper(PARTY.party_name) party_name, PARTY.category_code category_code, 'HZ_PARTY_SITES' owner_table_name, SITE.party_site_id owner_table_id, PARTY.duns_number_c from HZ_PARTY_SITES SITE, HZ_LOCATIONS LOC, HZ_PARTIES PARTY where SITE.status = 'A' and SITE.party_id = PARTY.party_id and PARTY.party_type in ('PERSON', 'ORGANIZATION') and PARTY.status = 'A' and LOC.location_id = SITE.location_id union all select /*+ parallel(PARTY) */ to_number(NULL) party_site_id , PARTY.party_id party_id , to_char(NULL) city , to_char(NULL) country , to_char(NULL) county , to_char(NULL) state , to_char(NULL) province , to_char(NULL) postal_code , PARTY.employees_total employees_total, PARTY.sic_code_type sic_code_type, PARTY.sic_code sic_code, upper(substr(PARTY.party_name,1,1)) party_name_substring, upper(PARTY.party_name) party_name, PARTY.category_code category_code, 'HZ_PARTIES' owner_table_name, PARTY.party_id owner_table_id, PARTY.duns_number_c from HZ_PARTIES PARTY where PARTY.party_type in ('PERSON', 'ORGANIZATION') and PARTY.status = 'A' ) X WHERE CNTPNT.owner_table_name(+) = X.owner_table_name and CNTPNT.owner_table_id(+) = X.owner_table_id and CNTPNT.status(+)='A' and CNTPNT.primary_flag(+)='Y' and CNTPNT.contact_point_type(+)='PHONE' and ORGPRO.party_id(+) = X.party_id and nvl(ORGPRO.effective_end_date(+),sysdate+1) > sysdate

View Text - HTML Formatted

SELECT /*+ PARALLEL(ORGPRO) PARALLEL(CNTPNT) PARALLEL(X) USE_HASH(ORGPRO CNTPNT X) */ X.PARTY_ID TRANS_OBJECT_ID
, X.PARTY_SITE_ID TRANS_DETAIL_OBJECT_ID
, X.PARTY_SITE_ID SQUAL_NUM02
, X.PARTY_ID SQUAL_NUM04
, UPPER(CNTPNT.PHONE_AREA_CODE) SQUAL_CHAR08
, UPPER(X.CATEGORY_CODE) SQUAL_CHAR09
, UPPER(ORGPRO.PREF_FUNCTIONAL_CURRENCY) SQUAL_CURC01
, UPPER(X.CITY) SQUAL_CHAR02
, ORGPRO.CURR_FY_POTENTIAL_REVENUE SQUAL_NUM06
, UPPER(X.COUNTRY) SQUAL_CHAR07
, UPPER(X.COUNTY) SQUAL_CHAR03
, X.PARTY_ID SQUAL_NUM01
, UPPER(X.PARTY_NAME_SUBSTRING) SQUAL_FC01
, UPPER(X.PARTY_NAME) SQUAL_CHAR01
, X.EMPLOYEES_TOTAL SQUAL_NUM05
, UPPER(X.POSTAL_CODE) SQUAL_CHAR06
, UPPER(X.PROVINCE) SQUAL_CHAR05
, X.PARTY_ID SQUAL_NUM03
, UPPER(X.SIC_CODE_TYPE||': '||X.SIC_CODE) SQUAL_CHAR10
, UPPER(X.STATE) SQUAL_CHAR04
, UPPER(X.DUNS_NUMBER_C) SQUAL_CHAR11
FROM HZ_ORGANIZATION_PROFILES ORGPRO
, HZ_CONTACT_POINTS CNTPNT
, (SELECT /*+ PARALLEL(PARTY) PARALLEL(SITE) PARALLEL(LOC) USE_HASH(SITE) USE_HASH(PARTY) USE_HASH(LOC) */ SITE.PARTY_SITE_ID PARTY_SITE_ID
, SITE.PARTY_ID PARTY_ID
, LOC.CITY CITY
, LOC.COUNTRY COUNTRY
, LOC.COUNTY COUNTY
, LOC.STATE STATE
, LOC.PROVINCE PROVINCE
, LOC.POSTAL_CODE POSTAL_CODE
, PARTY.EMPLOYEES_TOTAL EMPLOYEES_TOTAL
, PARTY.SIC_CODE_TYPE SIC_CODE_TYPE
, PARTY.SIC_CODE SIC_CODE
, UPPER(SUBSTR(PARTY.PARTY_NAME
, 1
, 1)) PARTY_NAME_SUBSTRING
, UPPER(PARTY.PARTY_NAME) PARTY_NAME
, PARTY.CATEGORY_CODE CATEGORY_CODE
, 'HZ_PARTY_SITES' OWNER_TABLE_NAME
, SITE.PARTY_SITE_ID OWNER_TABLE_ID
, PARTY.DUNS_NUMBER_C
FROM HZ_PARTY_SITES SITE
, HZ_LOCATIONS LOC
, HZ_PARTIES PARTY
WHERE SITE.STATUS = 'A'
AND SITE.PARTY_ID = PARTY.PARTY_ID
AND PARTY.PARTY_TYPE IN ('PERSON'
, 'ORGANIZATION')
AND PARTY.STATUS = 'A'
AND LOC.LOCATION_ID = SITE.LOCATION_ID UNION ALL SELECT /*+ PARALLEL(PARTY) */ TO_NUMBER(NULL) PARTY_SITE_ID
, PARTY.PARTY_ID PARTY_ID
, TO_CHAR(NULL) CITY
, TO_CHAR(NULL) COUNTRY
, TO_CHAR(NULL) COUNTY
, TO_CHAR(NULL) STATE
, TO_CHAR(NULL) PROVINCE
, TO_CHAR(NULL) POSTAL_CODE
, PARTY.EMPLOYEES_TOTAL EMPLOYEES_TOTAL
, PARTY.SIC_CODE_TYPE SIC_CODE_TYPE
, PARTY.SIC_CODE SIC_CODE
, UPPER(SUBSTR(PARTY.PARTY_NAME
, 1
, 1)) PARTY_NAME_SUBSTRING
, UPPER(PARTY.PARTY_NAME) PARTY_NAME
, PARTY.CATEGORY_CODE CATEGORY_CODE
, 'HZ_PARTIES' OWNER_TABLE_NAME
, PARTY.PARTY_ID OWNER_TABLE_ID
, PARTY.DUNS_NUMBER_C
FROM HZ_PARTIES PARTY
WHERE PARTY.PARTY_TYPE IN ('PERSON'
, 'ORGANIZATION')
AND PARTY.STATUS = 'A' ) X
WHERE CNTPNT.OWNER_TABLE_NAME(+) = X.OWNER_TABLE_NAME
AND CNTPNT.OWNER_TABLE_ID(+) = X.OWNER_TABLE_ID
AND CNTPNT.STATUS(+)='A'
AND CNTPNT.PRIMARY_FLAG(+)='Y'
AND CNTPNT.CONTACT_POINT_TYPE(+)='PHONE'
AND ORGPRO.PARTY_ID(+) = X.PARTY_ID
AND NVL(ORGPRO.EFFECTIVE_END_DATE(+)
, SYSDATE+1) > SYSDATE