View: ARBV_CUSTOMERS

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.ARBV_CUSTOMERS

View Text

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

Columns