VIEW: APPS.IBY_EXT_FC_PAYER_1_0_V

Source

View Text - Preformatted

SELECT iby_sum.trxnmid trxnmid, hzp.party_id party_id, hzp.party_number, hzp.party_name, nvl(hzp.party_type, 'PERSON'), decode(hzp.party_type, 'ORGANIZATION', hzp.organization_name_phonetic, 'PERSON', hzp.person_first_name_phonetic || ' ' || hzp.person_last_name_phonetic) alternate_name, hca.cust_account_id, hca.account_number, hou.organization_id org_id, hou.name operating_unit, hcasu.cust_acct_site_id, hcasu.site_use_id account_site_use_id, hcasu.location, iby_sum.bill_to_address_id, decode(iby_sum.instrtype, 'BANKACCOUNT', iby_fd_extract_gen_pvt.get_payee_taxregistration(hzp.party_id, NULL), NULL) tax_registration_number, hzp.jgzz_fiscal_code le_registration_number , hzp.attribute_category party_attr_cat FROM iby_trxn_summaries_all iby_sum, hz_parties hzp, hz_cust_accounts hca, hz_cust_site_uses_all hcasu, hr_all_organization_units_tl hou WHERE hzp.party_id(+) = iby_sum.payer_party_id AND iby_sum.cust_account_id = hca.cust_account_id(+) AND iby_sum.acct_site_use_id = hcasu.site_use_id(+) AND iby_sum.org_id = hou.organization_id(+) AND hou.LANGUAGE(+) = userenv('LANG')

View Text - HTML Formatted

SELECT IBY_SUM.TRXNMID TRXNMID
, HZP.PARTY_ID PARTY_ID
, HZP.PARTY_NUMBER
, HZP.PARTY_NAME
, NVL(HZP.PARTY_TYPE
, 'PERSON')
, DECODE(HZP.PARTY_TYPE
, 'ORGANIZATION'
, HZP.ORGANIZATION_NAME_PHONETIC
, 'PERSON'
, HZP.PERSON_FIRST_NAME_PHONETIC || ' ' || HZP.PERSON_LAST_NAME_PHONETIC) ALTERNATE_NAME
, HCA.CUST_ACCOUNT_ID
, HCA.ACCOUNT_NUMBER
, HOU.ORGANIZATION_ID ORG_ID
, HOU.NAME OPERATING_UNIT
, HCASU.CUST_ACCT_SITE_ID
, HCASU.SITE_USE_ID ACCOUNT_SITE_USE_ID
, HCASU.LOCATION
, IBY_SUM.BILL_TO_ADDRESS_ID
, DECODE(IBY_SUM.INSTRTYPE
, 'BANKACCOUNT'
, IBY_FD_EXTRACT_GEN_PVT.GET_PAYEE_TAXREGISTRATION(HZP.PARTY_ID
, NULL)
, NULL) TAX_REGISTRATION_NUMBER
, HZP.JGZZ_FISCAL_CODE LE_REGISTRATION_NUMBER
, HZP.ATTRIBUTE_CATEGORY PARTY_ATTR_CAT
FROM IBY_TRXN_SUMMARIES_ALL IBY_SUM
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HCA
, HZ_CUST_SITE_USES_ALL HCASU
, HR_ALL_ORGANIZATION_UNITS_TL HOU
WHERE HZP.PARTY_ID(+) = IBY_SUM.PAYER_PARTY_ID
AND IBY_SUM.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID(+)
AND IBY_SUM.ACCT_SITE_USE_ID = HCASU.SITE_USE_ID(+)
AND IBY_SUM.ORG_ID = HOU.ORGANIZATION_ID(+)
AND HOU.LANGUAGE(+) = USERENV('LANG')