VIEW: APPS.AR_DRAWEE_CUSTOMERS_H_V

Source

View Text - Preformatted

SELECT /*+ INDEX(he AR_XLA_LINES_EXTRACT_N1) */ ca2.account_number draw_cust_account_number ,ca2.customer_type draw_cust_type ,ca2.cust_account_id draw_cust_account_id ,ca2.global_attribute1 draw_cust_global_attr1 ,ca2.global_attribute10 draw_cust_global_attr10 ,ca2.global_attribute12 draw_cust_global_attr12 ,ca2.global_attribute9 draw_cust_global_attr9 ,ca2.global_attribute_category draw_cust_global_attr_cat ,ca2.npa_number draw_cust_npa_number ,p2.category_code draw_cust_cat_code ,p2.city draw_cust_city ,p2.country draw_cust_country ,p2.county draw_cust_county ,p2.group_type draw_cust_group_type ,p2.gsa_indicator_flag draw_cust_gsa_flag ,p2.jgzz_fiscal_code draw_cust_fiscal_code ,p2.known_as draw_cust_alternate_name ,p2.party_id draw_cust_party_id ,p2.party_name draw_cust_party_name ,p2.party_number draw_cust_party_number ,p2.party_type draw_cust_party_type ,p2.postal_code draw_cust_postal_code ,p2.sic_code_type draw_cust_province ,p2.state draw_cust_state ,p2.tax_reference draw_cust_tax_reference ,he.event_id event_id FROM hz_cust_accounts ca2 ,hz_parties p2 ,ar_xla_lines_extract he WHERE ca2.cust_account_id = he.drawee_customer_id AND he.level_flag = 'H' AND ca2.party_id = p2.party_id

View Text - HTML Formatted

SELECT /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */ CA2.ACCOUNT_NUMBER DRAW_CUST_ACCOUNT_NUMBER
, CA2.CUSTOMER_TYPE DRAW_CUST_TYPE
, CA2.CUST_ACCOUNT_ID DRAW_CUST_ACCOUNT_ID
, CA2.GLOBAL_ATTRIBUTE1 DRAW_CUST_GLOBAL_ATTR1
, CA2.GLOBAL_ATTRIBUTE10 DRAW_CUST_GLOBAL_ATTR10
, CA2.GLOBAL_ATTRIBUTE12 DRAW_CUST_GLOBAL_ATTR12
, CA2.GLOBAL_ATTRIBUTE9 DRAW_CUST_GLOBAL_ATTR9
, CA2.GLOBAL_ATTRIBUTE_CATEGORY DRAW_CUST_GLOBAL_ATTR_CAT
, CA2.NPA_NUMBER DRAW_CUST_NPA_NUMBER
, P2.CATEGORY_CODE DRAW_CUST_CAT_CODE
, P2.CITY DRAW_CUST_CITY
, P2.COUNTRY DRAW_CUST_COUNTRY
, P2.COUNTY DRAW_CUST_COUNTY
, P2.GROUP_TYPE DRAW_CUST_GROUP_TYPE
, P2.GSA_INDICATOR_FLAG DRAW_CUST_GSA_FLAG
, P2.JGZZ_FISCAL_CODE DRAW_CUST_FISCAL_CODE
, P2.KNOWN_AS DRAW_CUST_ALTERNATE_NAME
, P2.PARTY_ID DRAW_CUST_PARTY_ID
, P2.PARTY_NAME DRAW_CUST_PARTY_NAME
, P2.PARTY_NUMBER DRAW_CUST_PARTY_NUMBER
, P2.PARTY_TYPE DRAW_CUST_PARTY_TYPE
, P2.POSTAL_CODE DRAW_CUST_POSTAL_CODE
, P2.SIC_CODE_TYPE DRAW_CUST_PROVINCE
, P2.STATE DRAW_CUST_STATE
, P2.TAX_REFERENCE DRAW_CUST_TAX_REFERENCE
, HE.EVENT_ID EVENT_ID
FROM HZ_CUST_ACCOUNTS CA2
, HZ_PARTIES P2
, AR_XLA_LINES_EXTRACT HE
WHERE CA2.CUST_ACCOUNT_ID = HE.DRAWEE_CUSTOMER_ID
AND HE.LEVEL_FLAG = 'H'
AND CA2.PARTY_ID = P2.PARTY_ID