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, IBY_FD_EXTRACT_GEN_PVT.Get_Payee_TaxRegistration(hzp.party_id, NULL) tax_registration_number, null 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
, IBY_FD_EXTRACT_GEN_PVT.GET_PAYEE_TAXREGISTRATION(HZP.PARTY_ID
, NULL) TAX_REGISTRATION_NUMBER
, NULL 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')