AR_CM_BILL_TO_CUST_H

Details

Schema: FUSION
Object owner: AR
Object type: VIEW

Columns

Name
CM_BILL_CUST_ACCOUNT_NUMBER CM_BILL_CUST_TYPE CM_BILL_CUST_ACCOUNT_ID CM_BILL_CUST_GLOBAL_ATTR1 CM_BILL_CUST_GLOBAL_ATTR10 CM_BILL_CUST_GLOBAL_ATTR12 CM_BILL_CUST_GLOBAL_ATTR9 CM_BILL_CUST_GLOBAL_ATTR_CAT CM_BILL_CUST_NPA_NUMBER CM_BILL_CUST_CAT_CODE CM_BILL_CUST_CITY CM_BILL_CUST_COUNTRY CM_BILL_CUST_COUNTY CM_BILL_CUST_GROUP_TYPE CM_BILL_CUST_GSA_FLAG CM_BILL_CUST_FISCAL_CODE CM_BILL_CUST_ALTERNATE_NAME CM_BILL_CUST_PARTY_ID CM_BILL_CUST_PARTY_NAME CM_BILL_CUST_PARTY_NUMBER CM_BILL_CUST_PARTY_TYPE CM_BILL_CUST_POSTAL_CODE CM_BILL_CUST_PROVINCE CM_BILL_CUST_STATE CM_BILL_CUST_TAX_REFERENCE LEDGER_ID EVENT_ID CM_BILL_CUST_CLASS_CODE CM_BILL_CUST_ATTR1 CM_BILL_CUST_ATTR2 CM_BILL_CUST_ATTR3 CM_BILL_CUST_ATTR4 CM_BILL_CUST_ATTR5 CM_BILL_CUST_ATTR6 CM_BILL_CUST_ATTR7 CM_BILL_CUST_ATTR8 CM_BILL_CUST_ATTR9 CM_BILL_CUST_ATTR10 CM_BILL_CUST_ATTR11 CM_BILL_CUST_ATTR12 CM_BILL_CUST_ATTR13 CM_BILL_CUST_ATTR14 CM_BILL_CUST_ATTR15 CM_BILL_CUST_ATTR_CATEGORY CM_BILL_SITE_CITY CM_BILL_SITE_COUNTRY CM_BILL_SITE_COUNTY CM_BILL_SITE_POSTAL_CODE CM_BILL_SITE_PROVINCE CM_BILL_SITE_STATE CM_BILL_TO_PARTYPRO_ATTR_CAT CM_BILL_TO_PARTYPRO_ATTR1 CM_BILL_TO_PARTYPRO_ATTR2 CM_BILL_TO_PARTYPRO_ATTR3 CM_BILL_TO_PARTYPRO_ATTR4 CM_BILL_TO_PARTYPRO_ATTR5 CM_BILL_TO_PARTYPRO_ATTR6 CM_BILL_TO_PARTYPRO_ATTR7 CM_BILL_TO_PARTYPRO_ATTR8 CM_BILL_TO_PARTYPRO_ATTR9 CM_BILL_TO_PARTYPRO_ATTR10 CM_BILL_TO_PARTYPRO_ATTR11 CM_BILL_TO_PARTYPRO_ATTR12 CM_BILL_TO_PARTYPRO_ATTR13 CM_BILL_TO_PARTYPRO_ATTR14 CM_BILL_TO_PARTYPRO_ATTR15 CM_BILL_TO_PARTYPRO_ATTR16 CM_BILL_TO_PARTYPRO_ATTR17 CM_BILL_TO_PARTYPRO_ATTR18 CM_BILL_TO_PARTYPRO_ATTR19 CM_BILL_TO_PARTYPRO_ATTR20 CM_BILL_TO_PARTYPRO_ATTR21 CM_BILL_TO_PARTYPRO_ATTR22 CM_BILL_TO_PARTYPRO_ATTR23 CM_BILL_TO_PARTYPRO_ATTR24 CM_BILL_TO_PARTYPRO_ATTR25 CM_BILL_TO_PARTYPRO_ATTR26 CM_BILL_TO_PARTYPRO_ATTR27 CM_BILL_TO_PARTYPRO_ATTR28 CM_BILL_TO_PARTYPRO_ATTR29 CM_BILL_TO_PARTYPRO_ATTR30 CM_BILL_TO_PARTYPRO_ATTRNUM1 CM_BILL_TO_PARTYPRO_ATTRNUM2 CM_BILL_TO_PARTYPRO_ATTRNUM3 CM_BILL_TO_PARTYPRO_ATTRNUM4 CM_BILL_TO_PARTYPRO_ATTRNUM5 CM_BILL_TO_PARTYPRO_ATTRNUM6 CM_BILL_TO_PARTYPRO_ATTRNUM7 CM_BILL_TO_PARTYPRO_ATTRNUM8 CM_BILL_TO_PARTYPRO_ATTRNUM9 CM_BILL_TO_PARTYPRO_ATTRNUM10 CM_BILL_TO_PARTYPRO_ATTRNUM11 CM_BILL_TO_PARTYPRO_ATTRNUM12 CM_BILL_TO_PARTYPRO_ATTRDATE1 CM_BILL_TO_PARTYPRO_ATTRDATE2 CM_BILL_TO_PARTYPRO_ATTRDATE3 CM_BILL_TO_PARTYPRO_ATTRDATE4 CM_BILL_TO_PARTYPRO_ATTRDATE5 CM_BILL_TO_PARTYPRO_ATTRDATE6 CM_BILL_TO_PARTYPRO_ATTRDATE7 CM_BILL_TO_PARTYPRO_ATTRDATE8 CM_BILL_TO_PARTYPRO_ATTRDATE9 CM_BILL_TO_PARTYPRO_ATTRDATE10 CM_BILL_TO_PARTYPRO_ATTRDATE11 CM_BILL_TO_PARTYPRO_ATTRDATE12

Name

CM_BILL_CUST_ACCOUNT_NUMBER

CM_BILL_CUST_TYPE

CM_BILL_CUST_ACCOUNT_ID

CM_BILL_CUST_GLOBAL_ATTR1

CM_BILL_CUST_GLOBAL_ATTR10

CM_BILL_CUST_GLOBAL_ATTR12

CM_BILL_CUST_GLOBAL_ATTR9

CM_BILL_CUST_GLOBAL_ATTR_CAT

CM_BILL_CUST_NPA_NUMBER

CM_BILL_CUST_CAT_CODE

CM_BILL_CUST_CITY

CM_BILL_CUST_COUNTRY

CM_BILL_CUST_COUNTY

CM_BILL_CUST_GROUP_TYPE

CM_BILL_CUST_GSA_FLAG

CM_BILL_CUST_FISCAL_CODE

CM_BILL_CUST_ALTERNATE_NAME

CM_BILL_CUST_PARTY_ID

CM_BILL_CUST_PARTY_NAME

CM_BILL_CUST_PARTY_NUMBER

CM_BILL_CUST_PARTY_TYPE

CM_BILL_CUST_POSTAL_CODE

CM_BILL_CUST_PROVINCE

CM_BILL_CUST_STATE

CM_BILL_CUST_TAX_REFERENCE

LEDGER_ID

EVENT_ID

CM_BILL_CUST_CLASS_CODE

CM_BILL_CUST_ATTR1

CM_BILL_CUST_ATTR2

CM_BILL_CUST_ATTR3

CM_BILL_CUST_ATTR4

CM_BILL_CUST_ATTR5

CM_BILL_CUST_ATTR6

CM_BILL_CUST_ATTR7

CM_BILL_CUST_ATTR8

CM_BILL_CUST_ATTR9

CM_BILL_CUST_ATTR10

CM_BILL_CUST_ATTR11

CM_BILL_CUST_ATTR12

CM_BILL_CUST_ATTR13

CM_BILL_CUST_ATTR14

CM_BILL_CUST_ATTR15

CM_BILL_CUST_ATTR_CATEGORY

CM_BILL_SITE_CITY

CM_BILL_SITE_COUNTRY

CM_BILL_SITE_COUNTY

CM_BILL_SITE_POSTAL_CODE

CM_BILL_SITE_PROVINCE

CM_BILL_SITE_STATE

CM_BILL_TO_PARTYPRO_ATTR_CAT

CM_BILL_TO_PARTYPRO_ATTR1

CM_BILL_TO_PARTYPRO_ATTR2

CM_BILL_TO_PARTYPRO_ATTR3

CM_BILL_TO_PARTYPRO_ATTR4

CM_BILL_TO_PARTYPRO_ATTR5

CM_BILL_TO_PARTYPRO_ATTR6

CM_BILL_TO_PARTYPRO_ATTR7

CM_BILL_TO_PARTYPRO_ATTR8

CM_BILL_TO_PARTYPRO_ATTR9

CM_BILL_TO_PARTYPRO_ATTR10

CM_BILL_TO_PARTYPRO_ATTR11

CM_BILL_TO_PARTYPRO_ATTR12

CM_BILL_TO_PARTYPRO_ATTR13

CM_BILL_TO_PARTYPRO_ATTR14

CM_BILL_TO_PARTYPRO_ATTR15

CM_BILL_TO_PARTYPRO_ATTR16

CM_BILL_TO_PARTYPRO_ATTR17

CM_BILL_TO_PARTYPRO_ATTR18

CM_BILL_TO_PARTYPRO_ATTR19

CM_BILL_TO_PARTYPRO_ATTR20

CM_BILL_TO_PARTYPRO_ATTR21

CM_BILL_TO_PARTYPRO_ATTR22

CM_BILL_TO_PARTYPRO_ATTR23

CM_BILL_TO_PARTYPRO_ATTR24

CM_BILL_TO_PARTYPRO_ATTR25

CM_BILL_TO_PARTYPRO_ATTR26

CM_BILL_TO_PARTYPRO_ATTR27

CM_BILL_TO_PARTYPRO_ATTR28

CM_BILL_TO_PARTYPRO_ATTR29

CM_BILL_TO_PARTYPRO_ATTR30

CM_BILL_TO_PARTYPRO_ATTRNUM1

CM_BILL_TO_PARTYPRO_ATTRNUM2

CM_BILL_TO_PARTYPRO_ATTRNUM3

CM_BILL_TO_PARTYPRO_ATTRNUM4

CM_BILL_TO_PARTYPRO_ATTRNUM5

CM_BILL_TO_PARTYPRO_ATTRNUM6

CM_BILL_TO_PARTYPRO_ATTRNUM7

CM_BILL_TO_PARTYPRO_ATTRNUM8

CM_BILL_TO_PARTYPRO_ATTRNUM9

CM_BILL_TO_PARTYPRO_ATTRNUM10

CM_BILL_TO_PARTYPRO_ATTRNUM11

CM_BILL_TO_PARTYPRO_ATTRNUM12

CM_BILL_TO_PARTYPRO_ATTRDATE1

CM_BILL_TO_PARTYPRO_ATTRDATE2

CM_BILL_TO_PARTYPRO_ATTRDATE3

CM_BILL_TO_PARTYPRO_ATTRDATE4

CM_BILL_TO_PARTYPRO_ATTRDATE5

CM_BILL_TO_PARTYPRO_ATTRDATE6

CM_BILL_TO_PARTYPRO_ATTRDATE7

CM_BILL_TO_PARTYPRO_ATTRDATE8

CM_BILL_TO_PARTYPRO_ATTRDATE9

CM_BILL_TO_PARTYPRO_ATTRDATE10

CM_BILL_TO_PARTYPRO_ATTRDATE11

CM_BILL_TO_PARTYPRO_ATTRDATE12

Query

SQL_Statement
SELECT /+INDEX(he ar_xla_lines_extract_n1)/ ca7.account_number cm_bill_cust_account_number, ca7.customer_type cm_bill_cust_type, ca7.cust_account_id cm_bill_cust_account_id, NULL cm_bill_cust_global_attr1, NULL cm_bill_cust_global_attr10, NULL cm_bill_cust_global_attr12, NULL cm_bill_cust_global_attr9, NULL cm_bill_cust_global_attr_cat, ca7.npa_number cm_bill_cust_npa_number, p7.category_code cm_bill_cust_cat_code, p7.city cm_bill_cust_city, p7.country cm_bill_cust_country, p7.county cm_bill_cust_county, p7.group_type cm_bill_cust_group_type, p7.gsa_indicator_flag cm_bill_cust_gsa_flag, p7.jgzz_fiscal_code cm_bill_cust_fiscal_code, NULL cm_bill_cust_alternate_name, p7.party_id cm_bill_cust_party_id, p7.party_name cm_bill_cust_party_name, p7.party_number cm_bill_cust_party_number, p7.party_type cm_bill_cust_party_type, p7.postal_code cm_bill_cust_postal_code, p7.province cm_bill_cust_province, p7.state cm_bill_cust_state, NULL cm_bill_cust_tax_reference, he.ledger_id ledger_id, he.event_id event_id, upper(ca7.customer_class_code) cm_bill_cust_class_code, ca7.attribute1 cm_bill_cust_attr1, ca7.attribute2 cm_bill_cust_attr2, ca7.attribute3 cm_bill_cust_attr3, ca7.attribute4 cm_bill_cust_attr4, ca7.attribute5 cm_bill_cust_attr5, ca7.attribute6 cm_bill_cust_attr6, ca7.attribute7 cm_bill_cust_attr7, ca7.attribute8 cm_bill_cust_attr8, ca7.attribute9 cm_bill_cust_attr9, ca7.attribute10 cm_bill_cust_attr10, ca7.attribute11 cm_bill_cust_attr11, ca7.attribute12 cm_bill_cust_attr12, ca7.attribute13 cm_bill_cust_attr13, ca7.attribute14 cm_bill_cust_attr14, ca7.attribute15 cm_bill_cust_attr15, ca7.attribute_category cm_bill_cust_attr_category, loc.city cm_bill_site_city, loc.country cm_bill_site_country, loc.county cm_bill_site_county, loc.postal_code cm_bill_site_postal_code, loc.province cm_bill_site_province, loc.state cm_bill_site_state, ppgt.attribute_category cm_bill_to_partypro_attr_cat, ppgt.attribute1 cm_bill_to_partypro_attr1, ppgt.attribute2 cm_bill_to_partypro_attr2, ppgt.attribute3 cm_bill_to_partypro_attr3, ppgt.attribute4 cm_bill_to_partypro_attr4, ppgt.attribute5 cm_bill_to_partypro_attr5, ppgt.attribute6 cm_bill_to_partypro_attr6, ppgt.attribute7 cm_bill_to_partypro_attr7, ppgt.attribute8 cm_bill_to_partypro_attr8, ppgt.attribute9 cm_bill_to_partypro_attr9, ppgt.attribute10 cm_bill_to_partypro_attr10, ppgt.attribute11 cm_bill_to_partypro_attr11, ppgt.attribute12 cm_bill_to_partypro_attr12, ppgt.attribute13 cm_bill_to_partypro_attr13, ppgt.attribute14 cm_bill_to_partypro_attr14, ppgt.attribute15 cm_bill_to_partypro_attr15, ppgt.attribute16 cm_bill_to_partypro_attr16, ppgt.attribute17 cm_bill_to_partypro_attr17, ppgt.attribute18 cm_bill_to_partypro_attr18, ppgt.attribute19 cm_bill_to_partypro_attr19, ppgt.attribute20 cm_bill_to_partypro_attr20, ppgt.attribute21 cm_bill_to_partypro_attr21, ppgt.attribute22 cm_bill_to_partypro_attr22, ppgt.attribute23 cm_bill_to_partypro_attr23, ppgt.attribute24 cm_bill_to_partypro_attr24, ppgt.attribute25 cm_bill_to_partypro_attr25, ppgt.attribute26 cm_bill_to_partypro_attr26, ppgt.attribute27 cm_bill_to_partypro_attr27, ppgt.attribute28 cm_bill_to_partypro_attr28, ppgt.attribute29 cm_bill_to_partypro_attr29, ppgt.attribute30 cm_bill_to_partypro_attr30, ppgt.attribute_number1 cm_bill_to_partypro_attrnum1, ppgt.attribute_number2 cm_bill_to_partypro_attrnum2, ppgt.attribute_number3 cm_bill_to_partypro_attrnum3, ppgt.attribute_number4 cm_bill_to_partypro_attrnum4, ppgt.attribute_number5 cm_bill_to_partypro_attrnum5, ppgt.attribute_number6 cm_bill_to_partypro_attrnum6, ppgt.attribute_number7 cm_bill_to_partypro_attrnum7, ppgt.attribute_number8 cm_bill_to_partypro_attrnum8, ppgt.attribute_number9 cm_bill_to_partypro_attrnum9, ppgt.attribute_number10 cm_bill_to_partypro_attrnum10, ppgt.attribute_number11 cm_bill_to_partypro_attrnum11, ppgt.attribute_number12 cm_bill_to_partypro_attrnum12, ppgt.attribute_date1 cm_bill_to_partypro_attrdate1, ppgt.attribute_date2 cm_bill_to_partypro_attrdate2, ppgt.attribute_date3 cm_bill_to_partypro_attrdate3, ppgt.attribute_date4 cm_bill_to_partypro_attrdate4, ppgt.attribute_date5 cm_bill_to_partypro_attrdate5, ppgt.attribute_date6 cm_bill_to_partypro_attrdate6, ppgt.attribute_date7 cm_bill_to_partypro_attrdate7, ppgt.attribute_date8 cm_bill_to_partypro_attrdate8, ppgt.attribute_date9 cm_bill_to_partypro_attrdate9, ppgt.attribute_date10 cm_bill_to_partypro_attrdate10, ppgt.attribute_date11 cm_bill_to_partypro_attrdate11, ppgt.attribute_date12 cm_bill_to_partypro_attrdate12 FROM hz_cust_accounts ca7, hz_parties p7, hz_cust_site_uses_all su, hz_cust_acct_sites_all st, hz_party_sites p_site, hz_locations loc, ar_xla_lines_extract he, ar_cust_party_profile_gt ppgt WHERE ca7.cust_account_id = he.bill_customer_id AND su.site_use_id = he.bill_site_use_id AND st.cust_acct_site_id = su.cust_acct_site_id AND p_site.party_site_id = st.party_site_id AND loc.location_id = p_site.location_id AND he.level_flag = 'H' AND ca7.party_id = p7.party_id AND ppgt.party_id = p7.party_id AND he.event_type_code IN ( 'CM_CREATE', 'CM_UPDATE' )

SQL_Statement

SELECT

/*+INDEX(he ar_xla_lines_extract_n1)*/

ca7.account_number cm_bill_cust_account_number,

ca7.customer_type cm_bill_cust_type,

ca7.cust_account_id cm_bill_cust_account_id,

NULL cm_bill_cust_global_attr1,

NULL cm_bill_cust_global_attr10,

NULL cm_bill_cust_global_attr12,

NULL cm_bill_cust_global_attr9,

NULL cm_bill_cust_global_attr_cat,

ca7.npa_number cm_bill_cust_npa_number,

p7.category_code cm_bill_cust_cat_code,

p7.city cm_bill_cust_city,

p7.country cm_bill_cust_country,

p7.county cm_bill_cust_county,

p7.group_type cm_bill_cust_group_type,

p7.gsa_indicator_flag cm_bill_cust_gsa_flag,

p7.jgzz_fiscal_code cm_bill_cust_fiscal_code,

NULL cm_bill_cust_alternate_name,

p7.party_id cm_bill_cust_party_id,

p7.party_name cm_bill_cust_party_name,

p7.party_number cm_bill_cust_party_number,

p7.party_type cm_bill_cust_party_type,

p7.postal_code cm_bill_cust_postal_code,

p7.province cm_bill_cust_province,

p7.state cm_bill_cust_state,

NULL cm_bill_cust_tax_reference,

he.ledger_id ledger_id,

he.event_id event_id,

upper(ca7.customer_class_code) cm_bill_cust_class_code,

ca7.attribute1 cm_bill_cust_attr1,

ca7.attribute2 cm_bill_cust_attr2,

ca7.attribute3 cm_bill_cust_attr3,

ca7.attribute4 cm_bill_cust_attr4,

ca7.attribute5 cm_bill_cust_attr5,

ca7.attribute6 cm_bill_cust_attr6,

ca7.attribute7 cm_bill_cust_attr7,

ca7.attribute8 cm_bill_cust_attr8,

ca7.attribute9 cm_bill_cust_attr9,

ca7.attribute10 cm_bill_cust_attr10,

ca7.attribute11 cm_bill_cust_attr11,

ca7.attribute12 cm_bill_cust_attr12,

ca7.attribute13 cm_bill_cust_attr13,

ca7.attribute14 cm_bill_cust_attr14,

ca7.attribute15 cm_bill_cust_attr15,

ca7.attribute_category cm_bill_cust_attr_category,

loc.city cm_bill_site_city,

loc.country cm_bill_site_country,

loc.county cm_bill_site_county,

loc.postal_code cm_bill_site_postal_code,

loc.province cm_bill_site_province,

loc.state cm_bill_site_state,

ppgt.attribute_category cm_bill_to_partypro_attr_cat,

ppgt.attribute1 cm_bill_to_partypro_attr1,

ppgt.attribute2 cm_bill_to_partypro_attr2,

ppgt.attribute3 cm_bill_to_partypro_attr3,

ppgt.attribute4 cm_bill_to_partypro_attr4,

ppgt.attribute5 cm_bill_to_partypro_attr5,

ppgt.attribute6 cm_bill_to_partypro_attr6,

ppgt.attribute7 cm_bill_to_partypro_attr7,

ppgt.attribute8 cm_bill_to_partypro_attr8,

ppgt.attribute9 cm_bill_to_partypro_attr9,

ppgt.attribute10 cm_bill_to_partypro_attr10,

ppgt.attribute11 cm_bill_to_partypro_attr11,

ppgt.attribute12 cm_bill_to_partypro_attr12,

ppgt.attribute13 cm_bill_to_partypro_attr13,

ppgt.attribute14 cm_bill_to_partypro_attr14,

ppgt.attribute15 cm_bill_to_partypro_attr15,

ppgt.attribute16 cm_bill_to_partypro_attr16,

ppgt.attribute17 cm_bill_to_partypro_attr17,

ppgt.attribute18 cm_bill_to_partypro_attr18,

ppgt.attribute19 cm_bill_to_partypro_attr19,

ppgt.attribute20 cm_bill_to_partypro_attr20,

ppgt.attribute21 cm_bill_to_partypro_attr21,

ppgt.attribute22 cm_bill_to_partypro_attr22,

ppgt.attribute23 cm_bill_to_partypro_attr23,

ppgt.attribute24 cm_bill_to_partypro_attr24,

ppgt.attribute25 cm_bill_to_partypro_attr25,

ppgt.attribute26 cm_bill_to_partypro_attr26,

ppgt.attribute27 cm_bill_to_partypro_attr27,

ppgt.attribute28 cm_bill_to_partypro_attr28,

ppgt.attribute29 cm_bill_to_partypro_attr29,

ppgt.attribute30 cm_bill_to_partypro_attr30,

ppgt.attribute_number1 cm_bill_to_partypro_attrnum1,

ppgt.attribute_number2 cm_bill_to_partypro_attrnum2,

ppgt.attribute_number3 cm_bill_to_partypro_attrnum3,

ppgt.attribute_number4 cm_bill_to_partypro_attrnum4,

ppgt.attribute_number5 cm_bill_to_partypro_attrnum5,

ppgt.attribute_number6 cm_bill_to_partypro_attrnum6,

ppgt.attribute_number7 cm_bill_to_partypro_attrnum7,

ppgt.attribute_number8 cm_bill_to_partypro_attrnum8,

ppgt.attribute_number9 cm_bill_to_partypro_attrnum9,

ppgt.attribute_number10 cm_bill_to_partypro_attrnum10,

ppgt.attribute_number11 cm_bill_to_partypro_attrnum11,

ppgt.attribute_number12 cm_bill_to_partypro_attrnum12,

ppgt.attribute_date1 cm_bill_to_partypro_attrdate1,

ppgt.attribute_date2 cm_bill_to_partypro_attrdate2,

ppgt.attribute_date3 cm_bill_to_partypro_attrdate3,

ppgt.attribute_date4 cm_bill_to_partypro_attrdate4,

ppgt.attribute_date5 cm_bill_to_partypro_attrdate5,

ppgt.attribute_date6 cm_bill_to_partypro_attrdate6,

ppgt.attribute_date7 cm_bill_to_partypro_attrdate7,

ppgt.attribute_date8 cm_bill_to_partypro_attrdate8,

ppgt.attribute_date9 cm_bill_to_partypro_attrdate9,

ppgt.attribute_date10 cm_bill_to_partypro_attrdate10,

ppgt.attribute_date11 cm_bill_to_partypro_attrdate11,

ppgt.attribute_date12 cm_bill_to_partypro_attrdate12

FROM

hz_cust_accounts ca7,

hz_parties p7,

hz_cust_site_uses_all su,

hz_cust_acct_sites_all st,

hz_party_sites p_site,

hz_locations loc,

ar_xla_lines_extract he,

ar_cust_party_profile_gt ppgt

WHERE

ca7.cust_account_id = he.bill_customer_id

AND su.site_use_id = he.bill_site_use_id

AND st.cust_acct_site_id = su.cust_acct_site_id

AND p_site.party_site_id = st.party_site_id

AND loc.location_id = p_site.location_id

AND he.level_flag = 'H'

AND ca7.party_id = p7.party_id

AND ppgt.party_id = p7.party_id

AND he.event_type_code IN ( 'CM_CREATE', 'CM_UPDATE' )