IBY_EXT_FC_PAYER_1_0

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
TRXNMID PARTY_ID PARTY_NUMBER PARTY_NAME PARTY_TYPE ALTERNATE_NAME CUST_ACCOUNT_ID ACCOUNT_NUMBER ORG_ID OPERATING_UNIT CUST_ACCT_SITE_ID ACCOUNT_SITE_USE_ID LOCATION BILL_TO_ADDRESS_ID TAX_REGISTRATION_NUMBER LE_REGISTRATION_NUMBER PARTY_ATTR_CAT

Name

TRXNMID

PARTY_ID

PARTY_NUMBER

PARTY_NAME

PARTY_TYPE

ALTERNATE_NAME

CUST_ACCOUNT_ID

ACCOUNT_NUMBER

ORG_ID

OPERATING_UNIT

CUST_ACCT_SITE_ID

ACCOUNT_SITE_USE_ID

LOCATION

BILL_TO_ADDRESS_ID

TAX_REGISTRATION_NUMBER

LE_REGISTRATION_NUMBER

PARTY_ATTR_CAT

Query

SQL_Statement
SELECT iby_sum.trxnmid trxnmid, hzp.party_id party_id, hzp.party_number, hzp.party_name, nvl(hzp.party_type, 'PERSON') party_type, decode(hzp.party_type, 'ORGANIZATION', party_name.party_name, 'PERSON', party_name.person_first_name \|\| ' ' \|\| party_name.person_last_name) 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_payer_taxregistration(iby_sum.cust_account_id, iby_sum.acct_site_use_id) tax_registration_number, org.JGZZ_FISCAL_CODE le_registration_number, hzp.attribute_category party_attr_cat FROM iby_trxn_summaries_all iby_sum, hz_parties hzp, HZ_ADDTNL_PARTY_NAMES party_name, hz_cust_accounts hca, hz_cust_site_uses_all hcasu, hr_all_organization_units_tl hou, HZ_ORGANIZATION_PROFILES org 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') AND party_name.party_id(+) = hzp.party_id AND party_name.party_name_type(+) = 'PHONETIC' AND org.party_id(+) = iby_sum.payer_party_id AND nvl(TRUNC(iby_sum.creation_date), sysdate) between nvl(TRUNC(org.effective_start_date (+)) , sysdate-1) and NVL(TRUNC(org.effective_end_date (+)), sysdate+1)

SQL_Statement

SELECT iby_sum.trxnmid trxnmid,

hzp.party_id party_id,

hzp.party_number,

hzp.party_name,

nvl(hzp.party_type, 'PERSON') party_type,

decode(hzp.party_type, 'ORGANIZATION', party_name.party_name, 'PERSON', party_name.person_first_name || ' ' || party_name.person_last_name) 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_payer_taxregistration(iby_sum.cust_account_id, iby_sum.acct_site_use_id) tax_registration_number,

org.JGZZ_FISCAL_CODE le_registration_number,

hzp.attribute_category party_attr_cat

FROM iby_trxn_summaries_all iby_sum,

hz_parties hzp,

HZ_ADDTNL_PARTY_NAMES party_name,

hz_cust_accounts hca,

hz_cust_site_uses_all hcasu,

hr_all_organization_units_tl hou,

HZ_ORGANIZATION_PROFILES org

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')

AND party_name.party_id(+) = hzp.party_id

AND party_name.party_name_type(+) = 'PHONETIC'

AND org.party_id(+) = iby_sum.payer_party_id

AND nvl(TRUNC(iby_sum.creation_date), sysdate) between nvl(TRUNC(org.effective_start_date (+)) , sysdate-1) and NVL(TRUNC(org.effective_end_date (+)), sysdate+1)