DBA Data[Home] [Help]

VIEW: APPS.OE_BIS_CUST_SAT_V

Source

View Text - Preformatted

SELECT SET_OF_BOOKS_ID ,SET_OF_BOOKS_NAME ,LEGAL_ENTITY_ID ,LEGAL_ENTITY_NAME ,OPERATING_UNIT_ID ,OPERATING_UNIT_NAME ,ORGANIZATION_ID ,ORGANIZATION_NAME ,INVENTORY_ITEM_ID ,CATEGORY_ID ,CATEGORY_DESC ,ITEM_DESCRIPTION ,INVENTORY_ITEM_NAME ,CUSTOMER_ID ,SALES_CHANNEL_CODE ,CUSTOMER_NAME ,AREA ,COUNTRY ,TRANSACTION_DATE ,DEL_SALES ,RET_SALES ,NET_SALES ,PERIOD_SET_NAME ,YEAR_PERIOD ,QUARTER_PERIOD ,MONTH_PERIOD ,HEADER_ID ,LINE_ID ,LOCATION_ID ,LOCATION_CODE ,REGION from oe_bis_cust_sat_t2
View Text - HTML Formatted

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