Product: | IBY - Payments |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IBY_EXT_FC_PAYER_1_0_V |
SELECT IBY_SUM.TRXNMID TRXNMID
, HZP.PARTY_ID PARTY_ID
, HZP.PARTY_NUMBER
, HZP.PARTY_NAME
, HZP.PARTY_TYPE
, 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
, 'CUSTOMER') 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_OPERATING_UNITS HOU
WHERE TO_CHAR(HZP.PARTY_ID(+))=IBY_SUM.PAYERID
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(+)