eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.EDW_DUNS_M_IV

Source

View Text - Preformatted


SELECT rowid 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 , DNMR_DOMESTIC_ULT_STATE_PROV operation_code from EDW_DUNS_M

View Text - HTML Formatted

SELECT ROWID 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
, DNMR_DOMESTIC_ULT_STATE_PROV OPERATION_CODE
FROM EDW_DUNS_M