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_LS_ACC_TRX_QUICK_V

Source

View Text - Preformatted


SELECT party.party_id party_id, party.party_name party_name, party.address1 || party.address2 || party.address3 || party.address4 address, party.city city, party.state state, party.postal_code postal_code, party.province province, party.country country, ftt.territory_short_name country_name, party.email_address email_address, acc.status status, alk.meaning status_mean, party.url url, acc.cust_account_id cust_account_id, party.person_first_name first_name, party.person_last_name last_name, to_char(NULL) role_type, to_char(NULL) meaning, acc.account_number account_number, acc.orig_system_reference orig_system_reference, party.jgzz_fiscal_code jgzz_fiscal_code FROM hz_parties party, fnd_territories_tl ftt, ar_lookups alk, hz_cust_accounts acc, hz_cust_acct_sites ca, hz_cust_site_uses su WHERE (party.party_type = 'ORGANIZATION' OR party.party_type = 'PERSON') AND party.country = ftt.territory_code(+) AND party.party_id = acc.party_id AND ftt.LANGUAGE(+) = userenv('LANG') AND ftt.source_lang(+) = userenv('LANG') AND alk.lookup_type = 'CODE_STATUS' AND alk.lookup_code = acc.status AND acc.cust_account_id = ca.cust_account_id AND ca.cust_acct_site_id = su.cust_acct_site_id GROUP BY party.party_id, party.party_name, party.address1, party.address2, party.address3, party.address4, party.city, party.state, party.postal_code, party.province, party.country, ftt.territory_short_name, party.email_address, acc.status, alk.meaning, party.url, acc.cust_account_id, party.person_first_name, party.person_last_name, acc.account_number, acc.orig_system_reference, party.jgzz_fiscal_code UNION ALL SELECT relp.party_id party_id, party.party_name party_name, party.address1 || party.address2 || party.address3 || party.address4 address, party.city city, party.state state, party.postal_code postal_code, party.province province, party.country country, NULL country_name, party.email_address email_address, acc.status status, NULL status_mean, party.url url, role.cust_account_id cust_account_id, party.person_first_name first_name, party.person_last_name last_name, role.role_type role_type, lkup.meaning meaning, acc.account_number, acc.orig_system_reference orig_system_reference, party.jgzz_fiscal_code jgzz_fiscal_code FROM hz_parties party, hz_relationships relp, hz_cust_account_roles role, hz_cust_accounts acc, hz_cust_acct_sites ca, hz_cust_site_uses su, ar_lookups lkup WHERE role.party_id = relp.party_id AND relp.subject_id = party.party_id AND relp.object_id = acc.party_id AND acc.cust_account_id = role.cust_account_id AND role.role_type = lkup.lookup_code AND lkup.lookup_type = 'ACCT_ROLE_TYPE' AND acc.cust_account_id = ca.cust_account_id AND ca.cust_acct_site_id = su.cust_acct_site_id GROUP BY relp.party_id, party.party_name, party.address1, party.address2, party.address3, party.address4, party.city, party.state, party.postal_code, party.province, party.country, party.email_address, acc.status, party.url, role.cust_account_id, party.person_first_name, party.person_last_name, role.role_type, lkup.meaning, acc.account_number, acc.orig_system_reference, party.jgzz_fiscal_code

View Text - HTML Formatted

SELECT PARTY.PARTY_ID PARTY_ID
, PARTY.PARTY_NAME PARTY_NAME
, PARTY.ADDRESS1 || PARTY.ADDRESS2 || PARTY.ADDRESS3 || PARTY.ADDRESS4 ADDRESS
, PARTY.CITY CITY
, PARTY.STATE STATE
, PARTY.POSTAL_CODE POSTAL_CODE
, PARTY.PROVINCE PROVINCE
, PARTY.COUNTRY COUNTRY
, FTT.TERRITORY_SHORT_NAME COUNTRY_NAME
, PARTY.EMAIL_ADDRESS EMAIL_ADDRESS
, ACC.STATUS STATUS
, ALK.MEANING STATUS_MEAN
, PARTY.URL URL
, ACC.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, PARTY.PERSON_FIRST_NAME FIRST_NAME
, PARTY.PERSON_LAST_NAME LAST_NAME
, TO_CHAR(NULL) ROLE_TYPE
, TO_CHAR(NULL) MEANING
, ACC.ACCOUNT_NUMBER ACCOUNT_NUMBER
, ACC.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, PARTY.JGZZ_FISCAL_CODE JGZZ_FISCAL_CODE
FROM HZ_PARTIES PARTY
, FND_TERRITORIES_TL FTT
, AR_LOOKUPS ALK
, HZ_CUST_ACCOUNTS ACC
, HZ_CUST_ACCT_SITES CA
, HZ_CUST_SITE_USES SU
WHERE (PARTY.PARTY_TYPE = 'ORGANIZATION' OR PARTY.PARTY_TYPE = 'PERSON')
AND PARTY.COUNTRY = FTT.TERRITORY_CODE(+)
AND PARTY.PARTY_ID = ACC.PARTY_ID
AND FTT.LANGUAGE(+) = USERENV('LANG')
AND FTT.SOURCE_LANG(+) = USERENV('LANG')
AND ALK.LOOKUP_TYPE = 'CODE_STATUS'
AND ALK.LOOKUP_CODE = ACC.STATUS
AND ACC.CUST_ACCOUNT_ID = CA.CUST_ACCOUNT_ID
AND CA.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID GROUP BY PARTY.PARTY_ID
, PARTY.PARTY_NAME
, PARTY.ADDRESS1
, PARTY.ADDRESS2
, PARTY.ADDRESS3
, PARTY.ADDRESS4
, PARTY.CITY
, PARTY.STATE
, PARTY.POSTAL_CODE
, PARTY.PROVINCE
, PARTY.COUNTRY
, FTT.TERRITORY_SHORT_NAME
, PARTY.EMAIL_ADDRESS
, ACC.STATUS
, ALK.MEANING
, PARTY.URL
, ACC.CUST_ACCOUNT_ID
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_LAST_NAME
, ACC.ACCOUNT_NUMBER
, ACC.ORIG_SYSTEM_REFERENCE
, PARTY.JGZZ_FISCAL_CODE UNION ALL SELECT RELP.PARTY_ID PARTY_ID
, PARTY.PARTY_NAME PARTY_NAME
, PARTY.ADDRESS1 || PARTY.ADDRESS2 || PARTY.ADDRESS3 || PARTY.ADDRESS4 ADDRESS
, PARTY.CITY CITY
, PARTY.STATE STATE
, PARTY.POSTAL_CODE POSTAL_CODE
, PARTY.PROVINCE PROVINCE
, PARTY.COUNTRY COUNTRY
, NULL COUNTRY_NAME
, PARTY.EMAIL_ADDRESS EMAIL_ADDRESS
, ACC.STATUS STATUS
, NULL STATUS_MEAN
, PARTY.URL URL
, ROLE.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, PARTY.PERSON_FIRST_NAME FIRST_NAME
, PARTY.PERSON_LAST_NAME LAST_NAME
, ROLE.ROLE_TYPE ROLE_TYPE
, LKUP.MEANING MEANING
, ACC.ACCOUNT_NUMBER
, ACC.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, PARTY.JGZZ_FISCAL_CODE JGZZ_FISCAL_CODE
FROM HZ_PARTIES PARTY
, HZ_RELATIONSHIPS RELP
, HZ_CUST_ACCOUNT_ROLES ROLE
, HZ_CUST_ACCOUNTS ACC
, HZ_CUST_ACCT_SITES CA
, HZ_CUST_SITE_USES SU
, AR_LOOKUPS LKUP
WHERE ROLE.PARTY_ID = RELP.PARTY_ID
AND RELP.SUBJECT_ID = PARTY.PARTY_ID
AND RELP.OBJECT_ID = ACC.PARTY_ID
AND ACC.CUST_ACCOUNT_ID = ROLE.CUST_ACCOUNT_ID
AND ROLE.ROLE_TYPE = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'ACCT_ROLE_TYPE'
AND ACC.CUST_ACCOUNT_ID = CA.CUST_ACCOUNT_ID
AND CA.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID GROUP BY RELP.PARTY_ID
, PARTY.PARTY_NAME
, PARTY.ADDRESS1
, PARTY.ADDRESS2
, PARTY.ADDRESS3
, PARTY.ADDRESS4
, PARTY.CITY
, PARTY.STATE
, PARTY.POSTAL_CODE
, PARTY.PROVINCE
, PARTY.COUNTRY
, PARTY.EMAIL_ADDRESS
, ACC.STATUS
, PARTY.URL
, ROLE.CUST_ACCOUNT_ID
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_LAST_NAME
, ROLE.ROLE_TYPE
, LKUP.MEANING
, ACC.ACCOUNT_NUMBER
, ACC.ORIG_SYSTEM_REFERENCE
, PARTY.JGZZ_FISCAL_CODE