VIEW: APPS.ARBV_CUSTOMERS

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ CU.cust_account_id , /* REGULAR ATTRIBUTES */ substrb(P.PARTY_NAME,1,50), CU.account_NUMBER , DECODE(P.PARTY_TYPE, 'ORGANIZATION',P.ORGANIZATION_NAME_PHONETIC,NULL) , '_LA:CU.STATUS:AR_LOOKUPS:CODE_STATUS:MEANING' , 'CUSTOMER', CU.ORIG_SYSTEM_REFERENCE , '_LA:CU.CUSTOMER_TYPE:AR_LOOKUPS:CUSTOMER_TYPE:MEANING' , CU.CUSTOMER_CLASS_CODE , '_LA:P.CATEGORY_CODE:AR_LOOKUPS:CUSTOMER_CATEGORY:MEANING' , CU.TAX_CODE , DECODE(P.PARTY_TYPE, 'ORGANIZATION',P.SIC_CODE, NULL) , P.JGZZ_FISCAL_CODE , P.TAX_REFERENCE , '_LA:CU.TAX_ROUNDING_RULE:AR_LOOKUPS:AR_TAX_ROUNDING_RULE:MEANING' , '_LA:CU.TAX_HEADER_LEVEL_FLAG:AR_LOOKUPS:YES/NO:MEANING' , '_LA:P.GSA_INDICATOR_FLAG:AR_LOOKUPS:YES/NO:MEANING' , '_LA:CU.SHIP_PARTIAL:AR_LOOKUPS:YES/NO:MEANING' , CU.SHIP_VIA , '_LA:CU.FOB_POINT:AR_LOOKUPS:FOB:MEANING' , '_LA:CU.FREIGHT_TERM:OE_LOOKUPS:FREIGHT_TERMS:MEANING' , '_LA:SALES_CHANNEL_CODE:OE_LOOKUPS:SALES_CHANNEL:MEANING' , DECODE(P.PARTY_TYPE, 'ORGANIZATION',P.EMPLOYEES_TOTAL, TO_NUMBER(NULL)) , DECODE(P.PARTY_TYPE, 'ORGANIZATION',P.YEAR_ESTABLISHED, TO_NUMBER(NULL)) , DECODE(P.PARTY_TYPE, 'ORGANIZATION',P.FISCAL_YEAREND_MONTH,NULL) , DECODE(P.PARTY_TYPE, 'ORGANIZATION',P.ANALYSIS_FY, NULL) , DECODE(P.PARTY_TYPE, 'ORGANIZATION',P.CURR_FY_POTENTIAL_REVENUE,TO_NUMBER(NULL)) , DECODE(P.PARTY_TYPE, 'ORGANIZATION',P.NEXT_FY_POTENTIAL_REVENUE, TO_NUMBER(NULL)) , '_LA:THIRD_PARTY_FLAG:AR_LOOKUPS:YES/NO:MEANING' , '_LA:REFERENCE_USE_FLAG:AR_LOOKUPS:YES/NO:MEANING' , '_LA:COMPETITOR_FLAG:AR_LOOKUPS:YES/NO:MEANING' , DECODE(P.PARTY_TYPE, 'ORGANIZATION',P.MISSION_STATEMENT,NULL) , '_LA:CP.ACCOUNT_STATUS:AR_LOOKUPS:ACCOUNT_STATUS:MEANING' , '_LA:CP.CREDIT_RATING:AR_LOOKUPS:CREDIT_RATING:MEANING' , CP.PERCENT_COLLECTABLE , '_LA:CP.RISK_CODE:AR_LOOKUPS:RISK_CODE:MEANING' , '_LA:CP.CREDIT_CHECKING:AR_LOOKUPS:YES/NO:MEANING' , '_LA:CP.CREDIT_HOLD:AR_LOOKUPS:YES/NO:MEANING' , NULL , '_LA:CP.OVERRIDE_TERMS:AR_LOOKUPS:YES/NO:MEANING' , '_LA:CP.DISCOUNT_TERMS:AR_LOOKUPS:YES/NO:MEANING' , CP.DISCOUNT_GRACE_DAYS , CP.PAYMENT_GRACE_DAYS , '_LA:CP.AUTO_REC_INCL_DISPUTED_FLAG:AR_LOOKUPS:YES/NO:MEANING' , '_LA:CP.SEND_STATEMENTS:AR_LOOKUPS:YES/NO:MEANING' , '_LA:CP.CREDIT_BALANCE_STATEMENTS:AR_LOOKUPS:YES/NO:MEANING' , '_LA:CP.DUNNING_LETTERS:AR_LOOKUPS:YES/NO:MEANING' , '_LA:CP.CONS_INV_FLAG:AR_LOOKUPS:YES/NO:MEANING' , '_LA:CP.CONS_INV_TYPE:AR_LOOKUPS:CONSINV_TYPE:MEANING' , '_LA:CP.INTEREST_CHARGES:AR_LOOKUPS:YES/NO:MEANING' , '_LA:CP.CHARGE_ON_FINANCE_CHARGE_FLAG:AR_LOOKUPS:YES/NO:MEANING' , CP.INTEREST_PERIOD_DAYS , '_LA:CP.TAX_PRINTING_OPTION:AR_LOOKUPS:TAX_PRINTING_OPTION:MEANING' , CP.CLEARING_DAYS , '_LA:CP.LOCKBOX_MATCHING_OPTION:AR_LOOKUPS:ARLPLB_MATCHING_OPTION:MEANING', P.URL , CU.WAREHOUSE_ID , CU.PRIMARY_SALESREP_ID , /*A.DUNNING_SITE_USE_ID*/to_number(NULL) , /*A.STATEMENT_SITE_USE_ID */ to_number(NULL), CU.ORDER_TYPE_ID , /* WHO COLUMNS */ CU.LAST_UPDATE_DATE , CU.LAST_UPDATED_BY , CU.CREATION_DATE , CU.CREATED_BY FROM HZ_PARTIES P, HZ_CUST_ACCOUNTS CU , HZ_CUSTOMER_PROFILES CP WHERE P.PARTY_ID = CU.PARTY_ID AND CU.CUST_ACCOUNT_ID = CP.CUST_ACCOUNT_ID AND CP.SITE_USE_ID IS NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ CU.CUST_ACCOUNT_ID
, /* REGULAR ATTRIBUTES */ SUBSTRB(P.PARTY_NAME
, 1
, 50)
, CU.ACCOUNT_NUMBER
, DECODE(P.PARTY_TYPE
, 'ORGANIZATION'
, P.ORGANIZATION_NAME_PHONETIC
, NULL)
, '_LA:CU.STATUS:AR_LOOKUPS:CODE_STATUS:MEANING'
, 'CUSTOMER'
, CU.ORIG_SYSTEM_REFERENCE
, '_LA:CU.CUSTOMER_TYPE:AR_LOOKUPS:CUSTOMER_TYPE:MEANING'
, CU.CUSTOMER_CLASS_CODE
, '_LA:P.CATEGORY_CODE:AR_LOOKUPS:CUSTOMER_CATEGORY:MEANING'
, CU.TAX_CODE
, DECODE(P.PARTY_TYPE
, 'ORGANIZATION'
, P.SIC_CODE
, NULL)
, P.JGZZ_FISCAL_CODE
, P.TAX_REFERENCE
, '_LA:CU.TAX_ROUNDING_RULE:AR_LOOKUPS:AR_TAX_ROUNDING_RULE:MEANING'
, '_LA:CU.TAX_HEADER_LEVEL_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:P.GSA_INDICATOR_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:CU.SHIP_PARTIAL:AR_LOOKUPS:YES/NO:MEANING'
, CU.SHIP_VIA
, '_LA:CU.FOB_POINT:AR_LOOKUPS:FOB:MEANING'
, '_LA:CU.FREIGHT_TERM:OE_LOOKUPS:FREIGHT_TERMS:MEANING'
, '_LA:SALES_CHANNEL_CODE:OE_LOOKUPS:SALES_CHANNEL:MEANING'
, DECODE(P.PARTY_TYPE
, 'ORGANIZATION'
, P.EMPLOYEES_TOTAL
, TO_NUMBER(NULL))
, DECODE(P.PARTY_TYPE
, 'ORGANIZATION'
, P.YEAR_ESTABLISHED
, TO_NUMBER(NULL))
, DECODE(P.PARTY_TYPE
, 'ORGANIZATION'
, P.FISCAL_YEAREND_MONTH
, NULL)
, DECODE(P.PARTY_TYPE
, 'ORGANIZATION'
, P.ANALYSIS_FY
, NULL)
, DECODE(P.PARTY_TYPE
, 'ORGANIZATION'
, P.CURR_FY_POTENTIAL_REVENUE
, TO_NUMBER(NULL))
, DECODE(P.PARTY_TYPE
, 'ORGANIZATION'
, P.NEXT_FY_POTENTIAL_REVENUE
, TO_NUMBER(NULL))
, '_LA:THIRD_PARTY_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:REFERENCE_USE_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:COMPETITOR_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, DECODE(P.PARTY_TYPE
, 'ORGANIZATION'
, P.MISSION_STATEMENT
, NULL)
, '_LA:CP.ACCOUNT_STATUS:AR_LOOKUPS:ACCOUNT_STATUS:MEANING'
, '_LA:CP.CREDIT_RATING:AR_LOOKUPS:CREDIT_RATING:MEANING'
, CP.PERCENT_COLLECTABLE
, '_LA:CP.RISK_CODE:AR_LOOKUPS:RISK_CODE:MEANING'
, '_LA:CP.CREDIT_CHECKING:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:CP.CREDIT_HOLD:AR_LOOKUPS:YES/NO:MEANING'
, NULL
, '_LA:CP.OVERRIDE_TERMS:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:CP.DISCOUNT_TERMS:AR_LOOKUPS:YES/NO:MEANING'
, CP.DISCOUNT_GRACE_DAYS
, CP.PAYMENT_GRACE_DAYS
, '_LA:CP.AUTO_REC_INCL_DISPUTED_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:CP.SEND_STATEMENTS:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:CP.CREDIT_BALANCE_STATEMENTS:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:CP.DUNNING_LETTERS:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:CP.CONS_INV_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:CP.CONS_INV_TYPE:AR_LOOKUPS:CONSINV_TYPE:MEANING'
, '_LA:CP.INTEREST_CHARGES:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:CP.CHARGE_ON_FINANCE_CHARGE_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, CP.INTEREST_PERIOD_DAYS
, '_LA:CP.TAX_PRINTING_OPTION:AR_LOOKUPS:TAX_PRINTING_OPTION:MEANING'
, CP.CLEARING_DAYS
, '_LA:CP.LOCKBOX_MATCHING_OPTION:AR_LOOKUPS:ARLPLB_MATCHING_OPTION:MEANING'
, P.URL
, CU.WAREHOUSE_ID
, CU.PRIMARY_SALESREP_ID
, /*A.DUNNING_SITE_USE_ID*/TO_NUMBER(NULL)
, /*A.STATEMENT_SITE_USE_ID */ TO_NUMBER(NULL)
, CU.ORDER_TYPE_ID
, /* WHO COLUMNS */ CU.LAST_UPDATE_DATE
, CU.LAST_UPDATED_BY
, CU.CREATION_DATE
, CU.CREATED_BY
FROM HZ_PARTIES P
, HZ_CUST_ACCOUNTS CU
, HZ_CUSTOMER_PROFILES CP
WHERE P.PARTY_ID = CU.PARTY_ID
AND CU.CUST_ACCOUNT_ID = CP.CUST_ACCOUNT_ID
AND CP.SITE_USE_ID IS NULL WITH READ ONLY