[Home] [Help] [Dependency Information]

VIEW: APPS.EDW_DUNS_M_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
,      DNMR_DOMESTIC_ULT_STATE_PROV
,      DNMR_DOMESTIC_ULT_TELEPHONE
,      DNMR_DUNS_NUMBER
,      DNMR_DUNS_NUM_DP
,      DNMR_DUNS_NUM_PK
,      DNMR_EMPLOYEES_TOTAL
,      DNMR_EXPORT_FLAG
,      DNMR_FAILURE_IND
,      DNMR_FAILURE_INDU_INCE_DFT
,      DNMR_FAILURE_INDU_PCNT_RANK
,      DNMR_FAILURE_NATL_INCE_DFT
,      DNMR_FAILURE_NATL_PCNT_RANK
,      DNMR_FAILURE_SCORE
,      DNMR_FEDERAL_TAX_ID
,      DNMR_FIRE_DISASTER_IND
,      DNMR_GLOBAL_ULT_ADDRESS
,      DNMR_GLOBAL_ULT_CITY
,      DNMR_GLOBAL_ULT_COUNTRY
,      DNMR_GLOBAL_ULT_DUNS
,      DNMR_GLOBAL_ULT_NAME
,      DNMR_GLOBAL_ULT_POSTAL_CODE
,      DNMR_GLOBAL_ULT_STATE_PROV
,      DNMR_GLOBAL_ULT_TELEPHONE
,      DNMR_HIGH_CREDIT
,      DNMR_TOTAL_DEBT
,      DNMR_TOTAL_PAYMENTS
,      DNMR_TRADE_STYLE
,      DNMR_USER_ATTRIBUTE1
,      DNMR_USER_ATTRIBUTE2
,      DNMR_USER_ATTRIBUTE3
,      DNMR_USER_ATTRIBUTE4
,      DNMR_USER_ATTRIBUTE5
,      DNMR_WOMAN_OWNED_FLAG
,      DNMR_ZIP_CODE
,      ALL_ALL_PK_KEY
,      DNMR_HIGH_RISK_IND
,      DNMR_HISTORY
,      DNMR_HQ_ADDRESS
,      DNMR_HQ_CITY
,      DNMR_HQ_COUNTRY
,      DNMR_HQ_DUNS
,      DNMR_HQ_FLAG
,      DNMR_HQ_NAME
,      DNMR_HQ_POSTAL_CODE
,      DNMR_HQ_STATE_PROV
,      DNMR_HQ_TELEPHONE
,      DNMR_IMPORT_FLAG
,      ALL_ALL_PK
,      ALL_NAME
,      HQTR_HQ_PK_KEY
,      HQTR_ADDRESS
,      HQTR_CITY
,      HQTR_COUNTRY
,      HQTR_DUNS_NUMBER
,      HQTR_HQ_DP
,      HQTR_HQ_PK
,      HQTR_INSTANCE
,      DNMR_INSTANCE
,      DNMR_INVENTORY
,      DNMR_ISO9000_REGISTRATION
,      DNMR_JUDGMENTS_COUNT
,      DNMR_LABOR_SURPLUS_FLAG
,      DNMR_LEGAL_STATUS
,      DNMR_LIENS_COUNT
,      DNMR_LOCATION_STATUS
,      DNMR_MINORITY_OWNED_FLAG
,      DNMR_MINORITY_OWNED_TYPE
,      DNMR_NAME
,      DNMR_NEGATIVE_PAYMENTS
,      HQTR_NAME
,      HQTR_POSTAL_CODE
,      HQTR_STATE_PROV
,      HQTR_TELEPHONE
,      HQTR_USER_ATTRIBUTE1
,      HQTR_USER_ATTRIBUTE2
,      HQTR_USER_ATTRIBUTE3
,      HQTR_USER_ATTRIBUTE4
,      HQTR_USER_ATTRIBUTE5
,      PRNT_PARENT_PK_KEY
,      PRNT_ADDRESS
,      PRNT_CITY
,      PRNT_COUNTRY
,      PRNT_DUNS_NUMBER
,      PRNT_INSTANCE
,      PRNT_NAME
,      PRNT_PARENT_DP
,      PRNT_PARENT_PK
,      PRNT_POSTAL_CODE
,      PRNT_STATE_PROV
,      PRNT_TELEPHONE
,      PRNT_USER_ATTRIBUTE1
,      PRNT_USER_ATTRIBUTE2
,      PRNT_USER_ATTRIBUTE3
,      PRNT_USER_ATTRIBUTE4
,      PRNT_USER_ATTRIBUTE5
,      DOME_DOMESTIC_ULT_PK_KEY
,      DOME_ADDRESS
,      DOME_CITY
,      DOME_COUNTRY
,      DOME_DOMESTIC_ULT_DP
,      DOME_DOMESTIC_ULT_PK
,      DOME_DUNS_NUMBER
,      DOME_INSTANCE
,      DOME_NAME
,      DOME_POSTAL_CODE
,      DOME_STATE_PROV
,      DOME_TELEPHONE
,      DOME_USER_ATTRIBUTE1
,      DOME_USER_ATTRIBUTE2
,      DOME_USER_ATTRIBUTE3
,      DOME_USER_ATTRIBUTE4
,      DOME_USER_ATTRIBUTE5
,      GLBL_GLOBAL_ULT_PK_KEY
,      GLBL_ADDRESS
,      GLBL_CITY
,      GLBL_COUNTRY
,      GLBL_DUNS_NUMBER
,      GLBL_GLOBAL_ULT_DP
,      GLBL_GLOBAL_ULT_PK
,      GLBL_INSTANCE
,      GLBL_NAME
,      GLBL_POSTAL_CODE
,      GLBL_STATE_PROV
,      GLBL_TELEPHONE
,      GLBL_USER_ATTRIBUTE1
,      GLBL_USER_ATTRIBUTE2
,      GLBL_USER_ATTRIBUTE3
,      GLBL_USER_ATTRIBUTE4
,      GLBL_USER_ATTRIBUTE5
,      DNMR_NET_PROFIT
,      DNMR_NET_WORTH
,      DNMR_OOB_IND
,      DNMR_OWNS_RENTS_IND
,      DNMR_PARENT_ADDRESS
,      DNMR_PARENT_CITY
,      DNMR_PARENT_COUNTRY
,      DNMR_PARENT_DUNS
,      DNMR_PARENT_NAME
,      DNMR_PARENT_POSTAL_CODE
,      DNMR_PARENT_STATE_PROV
,      DNMR_PARENT_TELEPHONE
,      DNMR_PAYDEX_CURRENT
,      DNMR_DUNS_NUM_PK_KEY
,      DNMR_ACCOUNTS_RECEIVABLES
,      DNMR_ADDRESS
,      DNMR_AVERAGE_HIGH_CREDIT
,      DNMR_BANKRUPTCY_IND
,      DNMR_BUSINESS_MOVED_IND
,      DNMR_CASH
,      DNMR_CEO_NAME
,      DNMR_PAYDEX_NORM
,      DNMR_PAYDEX_PRIOR_Q1
,      DNMR_PAYDEX_PRIOR_Q2
,      DNMR_PAYDEX_PRIOR_Q3
,      DNMR_PREV_CURRENT_ASSETS
,      DNMR_PREV_CURRENT_LIABILITIES
,      DNMR_PREV_NET_WORTH
,      DNMR_PREV_SALES
,      DNMR_PREV_STATEMENT_DATE
,      DNMR_PREV_STATEMENT_TYPE
,      DNMR_PREV_TOTAL_ASSETS
,      DNMR_REPORT_BASE_DATE
,      DNMR_CEO_TITLE
,      DNMR_CITY
,      DNMR_COMPANY_NAME
,      DNMR_CONG_DIST_CODE1
,      DNMR_CONG_DIST_CODE2
,      DNMR_CONG_DIST_CODE3
,      DNMR_CONTROL_YEAR
,      DNMR_COUNTRY
,      DNMR_CRIMINAL_PROCEEDINGS_IND
,      DNMR_CURRENT_ASSETS
,      DNMR_CURRENT_LIABILITIES
,      DNMR_CURRENT_STATEMENT_DATE
,      DNMR_SALES
,      DNMR_SDB_ENTRANCE_DATE
,      DNMR_SDB_EXIT_DATE
,      DNMR_SIC1_DESCRIPTION
,      DNMR_SIC_CODE1
,      DNMR_SIC_CODE2
,      DNMR_SLOW_PAYMENTS
,      DNMR_SMALL_BUSINESS_FLAG
,      DNMR_STATE_PROV
,      DNMR_SUITS_COUNT
,      DNMR_TELEPHONE
,      DNMR_TOTAL_ASSETS
,      DNMR_CURRENT_STATEMENT_TYPE
,      DNMR_DEBARMENT_FLAG
,      DNMR_DELINQUENCY_SCORE
,      DNMR_DISADVANTAGED_FLAG
,      DNMR_DNB_LAST_UPDATE_DATE
,      DNMR_DNB_RATING
,      DNMR_DOMESTIC_ULT_ADDRESS
,      DNMR_DOMESTIC_ULT_CITY
,      DNMR_DOMESTIC_ULT_COUNTRY
,      DNMR_DOMESTIC_ULT_DUNS
,      DNMR_DOMESTIC_ULT_NAME
,      DNMR_DOMESTIC_ULT_POSTAL_CODE
,      OPERATION_CODE
FROM APPS.EDW_DUNS_M_IV;

Dependencies

[top of page]

APPS

EDW_DUNS_M

APPS.EDW_DUNS_M_IV is not referenced by any database object