1. Tables and Views for Financials
  2. AR_CM_SOLD_TO_CUST_H_V

AR_CM_SOLD_TO_CUST_H_V

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: VIEW

Columns

Name

CM_SOLD_CUST_ACCOUNT_NUMBER

CM_SOLD_CUST_TYPE

CM_SOLD_CUST_ACCOUNT_ID

CM_SOLD_CUST_GLOBAL_ATTR1

CM_SOLD_CUST_GLOBAL_ATTR10

CM_SOLD_CUST_GLOBAL_ATTR12

CM_SOLD_CUST_GLOBAL_ATTR9

CM_SOLD_CUST_GLOBAL_ATTR_CAT

CM_SOLD_CUST_NPA_NUMBER

CM_SOLD_CUST_AREA_CODE

CM_SOLD_CUST_CAT_CODE

CM_SOLD_CUST_CITY

CM_SOLD_CUST_COUNTRY

CM_SOLD_CUST_COUNTY

CM_SOLD_CUST_GROUP_TYPE

CM_SOLD_CUST_GSA_FLAG

CM_SOLD_CUST_FISCAL_CODE

CM_SOLD_CUST_PARTY_ID

CM_SOLD_CUST_PARTY_NAME

CM_SOLD_CUST_PARTY_NUMBER

CM_SOLD_CUST_PARTY_TYPE

CM_SOLD_CUST_POSTAL_CODE

CM_SOLD_CUST_PROVINCE

CM_SOLD_CUST_STATE

CM_SOLD_CUST_TAX_REFERENCE

EVENT_ID

LEDGER_ID

CM_SOLD_TO_PARTYPRO_ATTR_CAT

CM_SOLD_TO_PARTYPRO_ATTR1

CM_SOLD_TO_PARTYPRO_ATTR2

CM_SOLD_TO_PARTYPRO_ATTR3

CM_SOLD_TO_PARTYPRO_ATTR4

CM_SOLD_TO_PARTYPRO_ATTR5

CM_SOLD_TO_PARTYPRO_ATTR6

CM_SOLD_TO_PARTYPRO_ATTR7

CM_SOLD_TO_PARTYPRO_ATTR8

CM_SOLD_TO_PARTYPRO_ATTR9

CM_SOLD_TO_PARTYPRO_ATTR10

CM_SOLD_TO_PARTYPRO_ATTR11

CM_SOLD_TO_PARTYPRO_ATTR12

CM_SOLD_TO_PARTYPRO_ATTR13

CM_SOLD_TO_PARTYPRO_ATTR14

CM_SOLD_TO_PARTYPRO_ATTR15

CM_SOLD_TO_PARTYPRO_ATTR16

CM_SOLD_TO_PARTYPRO_ATTR17

CM_SOLD_TO_PARTYPRO_ATTR18

CM_SOLD_TO_PARTYPRO_ATTR19

CM_SOLD_TO_PARTYPRO_ATTR20

CM_SOLD_TO_PARTYPRO_ATTR21

CM_SOLD_TO_PARTYPRO_ATTR22

CM_SOLD_TO_PARTYPRO_ATTR23

CM_SOLD_TO_PARTYPRO_ATTR24

CM_SOLD_TO_PARTYPRO_ATTR25

CM_SOLD_TO_PARTYPRO_ATTR26

CM_SOLD_TO_PARTYPRO_ATTR27

CM_SOLD_TO_PARTYPRO_ATTR28

CM_SOLD_TO_PARTYPRO_ATTR29

CM_SOLD_TO_PARTYPRO_ATTR30

CM_SOLD_TO_PARTYPRO_ATTRNUM1

CM_SOLD_TO_PARTYPRO_ATTRNUM2

CM_SOLD_TO_PARTYPRO_ATTRNUM3

CM_SOLD_TO_PARTYPRO_ATTRNUM4

CM_SOLD_TO_PARTYPRO_ATTRNUM5

CM_SOLD_TO_PARTYPRO_ATTRNUM6

CM_SOLD_TO_PARTYPRO_ATTRNUM7

CM_SOLD_TO_PARTYPRO_ATTRNUM8

CM_SOLD_TO_PARTYPRO_ATTRNUM9

CM_SOLD_TO_PARTYPRO_ATTRNUM10

CM_SOLD_TO_PARTYPRO_ATTRNUM11

CM_SOLD_TO_PARTYPRO_ATTRNUM12

CM_SOLD_TO_PARTYPRO_ATTRDATE1

CM_SOLD_TO_PARTYPRO_ATTRDATE2

CM_SOLD_TO_PARTYPRO_ATTRDATE3

CM_SOLD_TO_PARTYPRO_ATTRDATE4

CM_SOLD_TO_PARTYPRO_ATTRDATE5

CM_SOLD_TO_PARTYPRO_ATTRDATE6

CM_SOLD_TO_PARTYPRO_ATTRDATE7

CM_SOLD_TO_PARTYPRO_ATTRDATE8

CM_SOLD_TO_PARTYPRO_ATTRDATE9

CM_SOLD_TO_PARTYPRO_ATTRDATE10

CM_SOLD_TO_PARTYPRO_ATTRDATE11

CM_SOLD_TO_PARTYPRO_ATTRDATE12

Query

SQL_Statement

SELECT

/*+INDEX(l ar_xla_lines_extract_n1)*/

NULL cm_sold_cust_account_number,

NULL cm_sold_cust_type,

NULL cm_sold_cust_account_id,

NULL cm_sold_cust_global_attr1,

NULL cm_sold_cust_global_attr10,

NULL cm_sold_cust_global_attr12,

NULL cm_sold_cust_global_attr9,

NULL cm_sold_cust_global_attr_cat,

NULL cm_sold_cust_npa_number,

p4.primary_phone_area_code cm_sold_cust_area_code,

p4.category_code cm_sold_cust_cat_code,

p4.city cm_sold_cust_city,

p4.country cm_sold_cust_country,

p4.county cm_sold_cust_county,

p4.group_type cm_sold_cust_group_type,

p4.gsa_indicator_flag cm_sold_cust_gsa_flag,

p4.jgzz_fiscal_code cm_sold_cust_fiscal_code,

p4.party_id cm_sold_cust_party_id,

p4.party_name cm_sold_cust_party_name,

p4.party_number cm_sold_cust_party_number,

p4.party_type cm_sold_cust_party_type,

p4.postal_code cm_sold_cust_postal_code,

p4.province cm_sold_cust_province,

p4.state cm_sold_cust_state,

NULL cm_sold_cust_tax_reference,

l.event_id event_id,

l.ledger_id ledger_id,

gt.attribute_category cm_sold_to_partypro_attr_cat,

gt.attribute1 cm_sold_to_partypro_attr1,

gt.attribute2 cm_sold_to_partypro_attr2,

gt.attribute3 cm_sold_to_partypro_attr3,

gt.attribute4 cm_sold_to_partypro_attr4,

gt.attribute5 cm_sold_to_partypro_attr5,

gt.attribute6 cm_sold_to_partypro_attr6,

gt.attribute7 cm_sold_to_partypro_attr7,

gt.attribute8 cm_sold_to_partypro_attr8,

gt.attribute9 cm_sold_to_partypro_attr9,

gt.attribute10 cm_sold_to_partypro_attr10,

gt.attribute11 cm_sold_to_partypro_attr11,

gt.attribute12 cm_sold_to_partypro_attr12,

gt.attribute13 cm_sold_to_partypro_attr13,

gt.attribute14 cm_sold_to_partypro_attr14,

gt.attribute15 cm_sold_to_partypro_attr15,

gt.attribute16 cm_sold_to_partypro_attr16,

gt.attribute17 cm_sold_to_partypro_attr17,

gt.attribute18 cm_sold_to_partypro_attr18,

gt.attribute19 cm_sold_to_partypro_attr19,

gt.attribute20 cm_sold_to_partypro_attr20,

gt.attribute21 cm_sold_to_partypro_attr21,

gt.attribute22 cm_sold_to_partypro_attr22,

gt.attribute23 cm_sold_to_partypro_attr23,

gt.attribute24 cm_sold_to_partypro_attr24,

gt.attribute25 cm_sold_to_partypro_attr25,

gt.attribute26 cm_sold_to_partypro_attr26,

gt.attribute27 cm_sold_to_partypro_attr27,

gt.attribute28 cm_sold_to_partypro_attr28,

gt.attribute29 cm_sold_to_partypro_attr29,

gt.attribute30 cm_sold_to_partypro_attr30,

gt.attribute_number1 cm_sold_to_partypro_attrnum1,

gt.attribute_number2 cm_sold_to_partypro_attrnum2,

gt.attribute_number3 cm_sold_to_partypro_attrnum3,

gt.attribute_number4 cm_sold_to_partypro_attrnum4,

gt.attribute_number5 cm_sold_to_partypro_attrnum5,

gt.attribute_number6 cm_sold_to_partypro_attrnum6,

gt.attribute_number7 cm_sold_to_partypro_attrnum7,

gt.attribute_number8 cm_sold_to_partypro_attrnum8,

gt.attribute_number9 cm_sold_to_partypro_attrnum9,

gt.attribute_number10 cm_sold_to_partypro_attrnum10,

gt.attribute_number11 cm_sold_to_partypro_attrnum11,

gt.attribute_number12 cm_sold_to_partypro_attrnum12,

gt.attribute_date1 cm_sold_to_partypro_attrdate1,

gt.attribute_date2 cm_sold_to_partypro_attrdate2,

gt.attribute_date3 cm_sold_to_partypro_attrdate3,

gt.attribute_date4 cm_sold_to_partypro_attrdate4,

gt.attribute_date5 cm_sold_to_partypro_attrdate5,

gt.attribute_date6 cm_sold_to_partypro_attrdate6,

gt.attribute_date7 cm_sold_to_partypro_attrdate7,

gt.attribute_date8 cm_sold_to_partypro_attrdate8,

gt.attribute_date9 cm_sold_to_partypro_attrdate9,

gt.attribute_date10 cm_sold_to_partypro_attrdate10,

gt.attribute_date11 cm_sold_to_partypro_attrdate11,

gt.attribute_date12 cm_sold_to_partypro_attrdate12

FROM

hz_parties p4,

ar_xla_lines_extract l,

ar_cust_party_profile_gt gt

WHERE

p4.party_id = l.sold_customer_id

AND gt.party_id = l.sold_customer_id

AND l.level_flag = 'H'