AR_SOLD_TO_CUSTOMERS_S_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

SOLD_CUST_ACCOUNT_NUMBER SOLD_CUST_TYPE SOLD_CUST_ACCOUNT_ID SOLD_CUST_GLOBAL_ATTR1 SOLD_CUST_GLOBAL_ATTR10 SOLD_CUST_GLOBAL_ATTR12 SOLD_CUST_GLOBAL_ATTR9 SOLD_CUST_GLOBAL_ATTR_CAT SOLD_CUST_NPA_NUMBER SOLD_CUST_CAT_CODE SOLD_CUST_CITY SOLD_CUST_COUNTRY SOLD_CUST_COUNTY SOLD_CUST_GROUP_TYPE SOLD_CUST_GSA_FLAG SOLD_CUST_FISCAL_CODE SOLD_CUST_PARTY_ID SOLD_CUST_PARTY_NAME SOLD_CUST_PARTY_NUMBER SOLD_CUST_PARTY_TYPE SOLD_CUST_POSTAL_CODE SOLD_CUST_PROVINCE SOLD_CUST_STATE SOLD_CUST_TAX_REFERENCE EVENT_ID LINE_NUMBER LEDGER_ID SOLD_CUSTOMER_CLASS_CODE SOLD_TO_PARTYPROF_ATTR_CAT SOLD_TO_PARTYPROF_ATTR1 SOLD_TO_PARTYPROF_ATTR2 SOLD_TO_PARTYPROF_ATTR3 SOLD_TO_PARTYPROF_ATTR4 SOLD_TO_PARTYPROF_ATTR5 SOLD_TO_PARTYPROF_ATTR6 SOLD_TO_PARTYPROF_ATTR7 SOLD_TO_PARTYPROF_ATTR8 SOLD_TO_PARTYPROF_ATTR9 SOLD_TO_PARTYPROF_ATTR10 SOLD_TO_PARTYPROF_ATTR11 SOLD_TO_PARTYPROF_ATTR12 SOLD_TO_PARTYPROF_ATTR13 SOLD_TO_PARTYPROF_ATTR14 SOLD_TO_PARTYPROF_ATTR15 SOLD_TO_PARTYPROF_ATTR16 SOLD_TO_PARTYPROF_ATTR17 SOLD_TO_PARTYPROF_ATTR18 SOLD_TO_PARTYPROF_ATTR19 SOLD_TO_PARTYPROF_ATTR20 SOLD_TO_PARTYPROF_ATTR21 SOLD_TO_PARTYPROF_ATTR22 SOLD_TO_PARTYPROF_ATTR23 SOLD_TO_PARTYPROF_ATTR24 SOLD_TO_PARTYPROF_ATTR25 SOLD_TO_PARTYPROF_ATTR26 SOLD_TO_PARTYPROF_ATTR27 SOLD_TO_PARTYPROF_ATTR28 SOLD_TO_PARTYPROF_ATTR29 SOLD_TO_PARTYPROF_ATTR30 SOLD_TO_PARTYPROF_ATTRNUM1 SOLD_TO_PARTYPROF_ATTRNUM2 SOLD_TO_PARTYPROF_ATTRNUM3 SOLD_TO_PARTYPROF_ATTRNUM4 SOLD_TO_PARTYPROF_ATTRNUM5 SOLD_TO_PARTYPROF_ATTRNUM6 SOLD_TO_PARTYPROF_ATTRNUM7 SOLD_TO_PARTYPROF_ATTRNUM8 SOLD_TO_PARTYPROF_ATTRNUM9 SOLD_TO_PARTYPROF_ATTRNUM10 SOLD_TO_PARTYPROF_ATTRNUM11 SOLD_TO_PARTYPROF_ATTRNUM12 SOLD_TO_PARTYPROF_ATTRDATE1 SOLD_TO_PARTYPROF_ATTRDATE2 SOLD_TO_PARTYPROF_ATTRDATE3 SOLD_TO_PARTYPROF_ATTRDATE4 SOLD_TO_PARTYPROF_ATTRDATE5 SOLD_TO_PARTYPROF_ATTRDATE6 SOLD_TO_PARTYPROF_ATTRDATE7 SOLD_TO_PARTYPROF_ATTRDATE8 SOLD_TO_PARTYPROF_ATTRDATE9 SOLD_TO_PARTYPROF_ATTRDATE10 SOLD_TO_PARTYPROF_ATTRDATE11 SOLD_TO_PARTYPROF_ATTRDATE12

Query

SQL_Statement

SELECT /*+INDEX(l ar_xla_lines_extract_n1)*/ NULL sold_cust_account_number, NULL sold_cust_type, NULL sold_cust_account_id, NULL sold_cust_global_attr1, NULL sold_cust_global_attr10, NULL sold_cust_global_attr12, NULL sold_cust_global_attr9, NULL sold_cust_global_attr_cat, NULL sold_cust_npa_number, gt.category_code sold_cust_cat_code, gt.city sold_cust_city, gt.country sold_cust_country, gt.county sold_cust_county, gt.group_type sold_cust_group_type, gt.gsa_indicator_flag sold_cust_gsa_flag, gt.jgzz_fiscal_code sold_cust_fiscal_code, gt.party_id sold_cust_party_id, gt.party_name sold_cust_party_name, gt.party_number sold_cust_party_number, gt.party_type sold_cust_party_type, gt.postal_code sold_cust_postal_code, gt.province sold_cust_province, gt.state sold_cust_state, NULL sold_cust_tax_reference, l.event_id event_id, l.line_number line_number, l.ledger_id ledger_id, NULL sold_customer_class_code, gt.attribute_category sold_to_partyprof_attr_cat, gt.attribute1 sold_to_partyprof_attr1, gt.attribute2 sold_to_partyprof_attr2, gt.attribute3 sold_to_partyprof_attr3, gt.attribute4 sold_to_partyprof_attr4, gt.attribute5 sold_to_partyprof_attr5, gt.attribute6 sold_to_partyprof_attr6, gt.attribute7 sold_to_partyprof_attr7, gt.attribute8 sold_to_partyprof_attr8, gt.attribute9 sold_to_partyprof_attr9, gt.attribute10 sold_to_partyprof_attr10, gt.attribute11 sold_to_partyprof_attr11, gt.attribute12 sold_to_partyprof_attr12, gt.attribute13 sold_to_partyprof_attr13, gt.attribute14 sold_to_partyprof_attr14, gt.attribute15 sold_to_partyprof_attr15, gt.attribute16 sold_to_partyprof_attr16, gt.attribute17 sold_to_partyprof_attr17, gt.attribute18 sold_to_partyprof_attr18, gt.attribute19 sold_to_partyprof_attr19, gt.attribute20 sold_to_partyprof_attr20, gt.attribute21 sold_to_partyprof_attr21, gt.attribute22 sold_to_partyprof_attr22, gt.attribute23 sold_to_partyprof_attr23, gt.attribute24 sold_to_partyprof_attr24, gt.attribute25 sold_to_partyprof_attr25, gt.attribute26 sold_to_partyprof_attr26, gt.attribute27 sold_to_partyprof_attr27, gt.attribute28 sold_to_partyprof_attr28, gt.attribute29 sold_to_partyprof_attr29, gt.attribute30 sold_to_partyprof_attr30, gt.attribute_number1 sold_to_partyprof_attrnum1, gt.attribute_number2 sold_to_partyprof_attrnum2, gt.attribute_number3 sold_to_partyprof_attrnum3, gt.attribute_number4 sold_to_partyprof_attrnum4, gt.attribute_number5 sold_to_partyprof_attrnum5, gt.attribute_number6 sold_to_partyprof_attrnum6, gt.attribute_number7 sold_to_partyprof_attrnum7, gt.attribute_number8 sold_to_partyprof_attrnum8, gt.attribute_number9 sold_to_partyprof_attrnum9, gt.attribute_number10 sold_to_partyprof_attrnum10, gt.attribute_number11 sold_to_partyprof_attrnum11, gt.attribute_number12 sold_to_partyprof_attrnum12, gt.attribute_date1 sold_to_partyprof_attrdate1, gt.attribute_date2 sold_to_partyprof_attrdate2, gt.attribute_date3 sold_to_partyprof_attrdate3, gt.attribute_date4 sold_to_partyprof_attrdate4, gt.attribute_date5 sold_to_partyprof_attrdate5, gt.attribute_date6 sold_to_partyprof_attrdate6, gt.attribute_date7 sold_to_partyprof_attrdate7, gt.attribute_date8 sold_to_partyprof_attrdate8, gt.attribute_date9 sold_to_partyprof_attrdate9, gt.attribute_date10 sold_to_partyprof_attrdate10, gt.attribute_date11 sold_to_partyprof_attrdate11, gt.attribute_date12 sold_to_partyprof_attrdate12 FROM ar_cust_party_profile_gt gt, ar_xla_lines_extract l WHERE gt.party_id = l.sold_customer_id AND ( ( l.event_class_code IN ( 'INVOICE', 'DEBIT_MEMO', 'DEPOSIT', 'GUARANTEE', 'CHARGEBACK', 'ADJUSTMENT' ) AND l.level_flag = 'H' ) OR ( l.event_class_code IN ( 'CREDIT_MEMO', 'RECEIPT' ) AND l.level_flag = 'L' AND l.from_to_flag = 'T' ) )