VIEW: OE.OE_BIS_CUST_SAT_T2#

Source

View Text - Preformatted

select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, SET_OF_BOOKS_NAME SET_OF_BOOKS_NAME, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME, OPERATING_UNIT_ID OPERATING_UNIT_ID, OPERATING_UNIT_NAME OPERATING_UNIT_NAME, ORGANIZATION_ID ORGANIZATION_ID, ORGANIZATION_NAME ORGANIZATION_NAME, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, CATEGORY_ID CATEGORY_ID, CATEGORY_DESC CATEGORY_DESC, ITEM_DESCRIPTION ITEM_DESCRIPTION, INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME, CUSTOMER_ID CUSTOMER_ID, SALES_CHANNEL_CODE SALES_CHANNEL_CODE, CUSTOMER_NAME CUSTOMER_NAME, AREA AREA, COUNTRY COUNTRY, TRANSACTION_DATE TRANSACTION_DATE, DEL_SALES DEL_SALES, RET_SALES RET_SALES, NET_SALES NET_SALES, PERIOD_SET_NAME PERIOD_SET_NAME, YEAR_PERIOD YEAR_PERIOD, QUARTER_PERIOD QUARTER_PERIOD, MONTH_PERIOD MONTH_PERIOD, HEADER_ID HEADER_ID, LINE_ID LINE_ID, LOCATION_ID LOCATION_ID, LOCATION_CODE LOCATION_CODE, REGION REGION from "OE"."OE_BIS_CUST_SAT_T2"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SET_OF_BOOKS_NAME SET_OF_BOOKS_NAME
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, LEGAL_ENTITY_NAME LEGAL_ENTITY_NAME
, OPERATING_UNIT_ID OPERATING_UNIT_ID
, OPERATING_UNIT_NAME OPERATING_UNIT_NAME
, ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_NAME ORGANIZATION_NAME
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CATEGORY_ID CATEGORY_ID
, CATEGORY_DESC CATEGORY_DESC
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME
, CUSTOMER_ID CUSTOMER_ID
, SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, CUSTOMER_NAME CUSTOMER_NAME
, AREA AREA
, COUNTRY COUNTRY
, TRANSACTION_DATE TRANSACTION_DATE
, DEL_SALES DEL_SALES
, RET_SALES RET_SALES
, NET_SALES NET_SALES
, PERIOD_SET_NAME PERIOD_SET_NAME
, YEAR_PERIOD YEAR_PERIOD
, QUARTER_PERIOD QUARTER_PERIOD
, MONTH_PERIOD MONTH_PERIOD
, HEADER_ID HEADER_ID
, LINE_ID LINE_ID
, LOCATION_ID LOCATION_ID
, LOCATION_CODE LOCATION_CODE
, REGION REGION
FROM "OE"."OE_BIS_CUST_SAT_T2"