[Home] [Help] [Dependency Information]

VIEW: APPS.EDW_DUNS_NUMBER_LTC_IV

Object Details

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ROW_ID
,      FAILURE_IND
,      FAILURE_INDU_INCE_DFT
,      FAILURE_INDU_PCNT_RANK
,      FAILURE_NATL_INCE_DFT
,      FAILURE_NATL_PCNT_RANK
,      FAILURE_SCORE
,      FEDERAL_TAX_ID
,      FIRE_DISASTER_IND
,      GLOBAL_ULT_ADDRESS
,      GLOBAL_ULT_CITY
,      GLOBAL_ULT_COUNTRY
,      GLOBAL_ULT_DUNS
,      GLOBAL_ULT_NAME
,      GLOBAL_ULT_POSTAL_CODE
,      GLOBAL_ULT_STATE_PROV
,      GLOBAL_ULT_TELEPHONE
,      HIGH_CREDIT
,      HIGH_RISK_IND
,      HISTORY
,      HQ_ADDRESS
,      HQ_CITY
,      HQ_COUNTRY
,      HQ_DUNS
,      HQ_FK
,      HQ_FK_KEY
,      HQ_FLAG
,      HQ_NAME
,      HQ_POSTAL_CODE
,      HQ_STATE_PROV
,      HQ_TELEPHONE
,      IMPORT_FLAG
,      INSTANCE
,      INVENTORY
,      ISO9000_REGISTRATION
,      JUDGMENTS_COUNT
,      LABOR_SURPLUS_FLAG
,      LAST_UPDATE_DATE
,      LEGAL_STATUS
,      LIENS_COUNT
,      LOCATION_STATUS
,      MINORITY_OWNED_FLAG
,      MINORITY_OWNED_TYPE
,      NAME
,      NEGATIVE_PAYMENTS
,      NET_PROFIT
,      NET_WORTH
,      OOB_IND
,      OWNS_RENTS_IND
,      PARENT_ADDRESS
,      PARENT_CITY
,      PARENT_COUNTRY
,      PARENT_DUNS
,      PARENT_FK
,      PARENT_FK_KEY
,      PARENT_NAME
,      PARENT_POSTAL_CODE
,      PARENT_STATE_PROV
,      PARENT_TELEPHONE
,      PAYDEX_CURRENT
,      PAYDEX_NORM
,      PAYDEX_PRIOR_Q1
,      PAYDEX_PRIOR_Q2
,      PAYDEX_PRIOR_Q3
,      PREV_CURRENT_ASSETS
,      PREV_CURRENT_LIABILITIES
,      PREV_NET_WORTH
,      PREV_SALES
,      PREV_STATEMENT_DATE
,      PREV_STATEMENT_TYPE
,      PREV_TOTAL_ASSETS
,      REPORT_BASE_DATE
,      SALES
,      SDB_ENTRANCE_DATE
,      SDB_EXIT_DATE
,      SIC1_DESCRIPTION
,      SIC_CODE1
,      SIC_CODE2
,      SLOW_PAYMENTS
,      SMALL_BUSINESS_FLAG
,      STATE_PROV
,      SUITS_COUNT
,      TELEPHONE
,      TOTAL_ASSETS
,      TOTAL_DEBT
,      TOTAL_PAYMENTS
,      TRADE_STYLE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      WOMAN_OWNED_FLAG
,      ZIP_CODE
,      ACCOUNTS_RECEIVABLES
,      ADDRESS
,      AVERAGE_HIGH_CREDIT
,      BANKRUPTCY_IND
,      BUSINESS_MOVED_IND
,      CASH
,      CEO_NAME
,      CEO_TITLE
,      CITY
,      COMPANY_NAME
,      CONG_DIST_CODE1
,      CONG_DIST_CODE2
,      CONG_DIST_CODE3
,      CONTROL_YEAR
,      COUNTRY
,      CREATION_DATE
,      CRIMINAL_PROCEEDINGS_IND
,      CURRENT_ASSETS
,      CURRENT_LIABILITIES
,      CURRENT_STATEMENT_DATE
,      CURRENT_STATEMENT_TYPE
,      DEBARMENT_FLAG
,      DELINQUENCY_SCORE
,      DISADVANTAGED_FLAG
,      DNB_LAST_UPDATE_DATE
,      DNB_RATING
,      DOMESTIC_ULT_ADDRESS
,      DOMESTIC_ULT_CITY
,      DOMESTIC_ULT_COUNTRY
,      DOMESTIC_ULT_DUNS
,      DOMESTIC_ULT_FK
,      DOMESTIC_ULT_FK_KEY
,      DOMESTIC_ULT_NAME
,      DOMESTIC_ULT_POSTAL_CODE
,      DOMESTIC_ULT_STATE_PROV
,      DOMESTIC_ULT_TELEPHONE
,      DUNS_NUMBER
,      DUNS_NUM_DP
,      DUNS_NUM_PK
,      DUNS_NUM_PK_KEY
,      EMPLOYEES_TOTAL
,      EXPORT_FLAG
,      OPERATION_CODE
FROM APPS.EDW_DUNS_NUMBER_LTC_IV;

Dependencies

[top of page]

APPS

EDW_DUNS_NUMBER_LTC

APPS.EDW_DUNS_NUMBER_LTC_IV is not referenced by any database object