DBA Data[Home] [Help]

VIEW: OSM.AS_LEAD_LINES_LOG#

Source

View Text - Preformatted

select SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID, ROLLING_FORECAST_FLAG ROLLING_FORECAST_FLAG, FORECAST_DATE FORECAST_DATE, SOURCE_PROMOTION_ID SOURCE_PROMOTION_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID, INTEREST_TYPE_ID INTEREST_TYPE_ID, LEAD_LINE_ID LEAD_LINE_ID, ORG_ID ORG_ID, OFFER_ID OFFER_ID, LOG_MODE LOG_MODE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LEAD_ID LEAD_ID, LOG_ID LOG_ID, PRODUCT_CATEGORY_ID PRODUCT_CATEGORY_ID, PRODUCT_CAT_SET_ID PRODUCT_CAT_SET_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ENDDAY_LOG_FLAG ENDDAY_LOG_FLAG from "OSM"."AS_LEAD_LINES_LOG"
View Text - HTML Formatted

SELECT SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
, ROLLING_FORECAST_FLAG ROLLING_FORECAST_FLAG
, FORECAST_DATE FORECAST_DATE
, SOURCE_PROMOTION_ID SOURCE_PROMOTION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, INTEREST_TYPE_ID INTEREST_TYPE_ID
, LEAD_LINE_ID LEAD_LINE_ID
, ORG_ID ORG_ID
, OFFER_ID OFFER_ID
, LOG_MODE LOG_MODE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LEAD_ID LEAD_ID
, LOG_ID LOG_ID
, PRODUCT_CATEGORY_ID PRODUCT_CATEGORY_ID
, PRODUCT_CAT_SET_ID PRODUCT_CAT_SET_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ENDDAY_LOG_FLAG ENDDAY_LOG_FLAG
FROM "OSM"."AS_LEAD_LINES_LOG"