VIEW: BOM.CST_BIS_MARGIN_SUMMARY#

Source

View Text - Preformatted

select LEGAL_ENTITY_ID LEGAL_ENTITY_ID, BUILD_ID BUILD_ID, SOURCE SOURCE, ROW_TYPE ROW_TYPE, ORIGIN ORIGIN, INVOICE_SOURCE INVOICE_SOURCE, PARENT_ROWID PARENT_ROWID, ORDER_NUMBER ORDER_NUMBER, ORG_ID ORG_ID, HEADER_ID HEADER_ID, ORDER_TYPE_ID ORDER_TYPE_ID, CUSTOMER_ID CUSTOMER_ID, SOLD_TO_CUSTOMER_NAME SOLD_TO_CUSTOMER_NAME, PRIMARY_SALESREP_ID PRIMARY_SALESREP_ID, SALES_CHANNEL_CODE SALES_CHANNEL_CODE, PARENT_INVENTORY_ITEM_ID PARENT_INVENTORY_ITEM_ID, PARENT_ORGANIZATION_ID PARENT_ORGANIZATION_ID, PARENT_LINE_ID PARENT_LINE_ID, PARENT_LINE_NUMBER PARENT_LINE_NUMBER, PARENT_ITEM_TYPE_CODE PARENT_ITEM_TYPE_CODE, PARENT_ATO_FLAG PARENT_ATO_FLAG, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, LINE_ID LINE_ID, LINE_TYPE_CODE LINE_TYPE_CODE, LINE_NUMBER LINE_NUMBER, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, SHIP_TO_CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME, INVOICE_TO_SITE_USE_ID INVOICE_TO_SITE_USE_ID, BILL_TO_CUSTOMER_NAME BILL_TO_CUSTOMER_NAME, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, ORIGINAL_GL_DATE ORIGINAL_GL_DATE, GL_DATE GL_DATE, INVOICE_LINE_QUANTITY INVOICE_LINE_QUANTITY, INVOICE_QUANTITY INVOICE_QUANTITY, ORDER_LINE_QUANTITY ORDER_LINE_QUANTITY, SHIP_QUANTITY SHIP_QUANTITY, INVOICED_AMOUNT INVOICED_AMOUNT, COGS_AMOUNT COGS_AMOUNT, SALES_ACCOUNT SALES_ACCOUNT, COGS_ACCOUNT COGS_ACCOUNT, TERRITORY_ID TERRITORY_ID, CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE, MARGIN MARGIN, MARGIN_PCT MARGIN_PCT, RETURN_REFERENCE_TYPE_CODE RETURN_REFERENCE_TYPE_CODE, RETURN_REFERENCE_ID RETURN_REFERENCE_ID, LINK_TO_LINE_ID LINK_TO_LINE_ID, RMA_HEADER_ID RMA_HEADER_ID, RMA_NUMBER RMA_NUMBER, RMA_INVENTORY_ITEM_ID RMA_INVENTORY_ITEM_ID, RMA_LINE_ID RMA_LINE_ID, RMA_LINE_NUMBER RMA_LINE_NUMBER, RMA_ORGANIZATION_ID RMA_ORGANIZATION_ID, RMA_LINE_TYPE_CODE RMA_LINE_TYPE_CODE, RMA_SHIP_TO_SITE_USE_ID RMA_SHIP_TO_SITE_USE_ID, RMA_INVOICE_INVENTORY_ITEM_ID RMA_INVOICE_INVENTORY_ITEM_ID, CR_TRX_ID CR_TRX_ID, CR_TRX_LINE_ID CR_TRX_LINE_ID, PERIOD_NAME_YEAR PERIOD_NAME_YEAR, PERIOD_NUM_YEAR PERIOD_NUM_YEAR, PERIOD_NAME_QTR PERIOD_NAME_QTR, PERIOD_NUM_QTR PERIOD_NUM_QTR, PERIOD_SEQ_QTR PERIOD_SEQ_QTR, PERIOD_NAME_MONTH PERIOD_NAME_MONTH, PERIOD_NUM_MONTH PERIOD_NUM_MONTH, PERIOD_SEQ_MONTH PERIOD_SEQ_MONTH, OE_ITEM_CATEGORY_ID OE_ITEM_CATEGORY_ID, AREA_CODE AREA_CODE, COUNTRY_CODE COUNTRY_CODE, REGION_CODE REGION_CODE, AREA_NAME AREA_NAME, COUNTRY_NAME COUNTRY_NAME, REGION_NAME REGION_NAME, OPERATING_UNIT_NAME OPERATING_UNIT_NAME, MARGIN_PK MARGIN_PK from "BOM"."CST_BIS_MARGIN_SUMMARY"

View Text - HTML Formatted

SELECT LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, BUILD_ID BUILD_ID
, SOURCE SOURCE
, ROW_TYPE ROW_TYPE
, ORIGIN ORIGIN
, INVOICE_SOURCE INVOICE_SOURCE
, PARENT_ROWID PARENT_ROWID
, ORDER_NUMBER ORDER_NUMBER
, ORG_ID ORG_ID
, HEADER_ID HEADER_ID
, ORDER_TYPE_ID ORDER_TYPE_ID
, CUSTOMER_ID CUSTOMER_ID
, SOLD_TO_CUSTOMER_NAME SOLD_TO_CUSTOMER_NAME
, PRIMARY_SALESREP_ID PRIMARY_SALESREP_ID
, SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, PARENT_INVENTORY_ITEM_ID PARENT_INVENTORY_ITEM_ID
, PARENT_ORGANIZATION_ID PARENT_ORGANIZATION_ID
, PARENT_LINE_ID PARENT_LINE_ID
, PARENT_LINE_NUMBER PARENT_LINE_NUMBER
, PARENT_ITEM_TYPE_CODE PARENT_ITEM_TYPE_CODE
, PARENT_ATO_FLAG PARENT_ATO_FLAG
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, LINE_ID LINE_ID
, LINE_TYPE_CODE LINE_TYPE_CODE
, LINE_NUMBER LINE_NUMBER
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, SHIP_TO_CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME
, INVOICE_TO_SITE_USE_ID INVOICE_TO_SITE_USE_ID
, BILL_TO_CUSTOMER_NAME BILL_TO_CUSTOMER_NAME
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, ORIGINAL_GL_DATE ORIGINAL_GL_DATE
, GL_DATE GL_DATE
, INVOICE_LINE_QUANTITY INVOICE_LINE_QUANTITY
, INVOICE_QUANTITY INVOICE_QUANTITY
, ORDER_LINE_QUANTITY ORDER_LINE_QUANTITY
, SHIP_QUANTITY SHIP_QUANTITY
, INVOICED_AMOUNT INVOICED_AMOUNT
, COGS_AMOUNT COGS_AMOUNT
, SALES_ACCOUNT SALES_ACCOUNT
, COGS_ACCOUNT COGS_ACCOUNT
, TERRITORY_ID TERRITORY_ID
, CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE
, MARGIN MARGIN
, MARGIN_PCT MARGIN_PCT
, RETURN_REFERENCE_TYPE_CODE RETURN_REFERENCE_TYPE_CODE
, RETURN_REFERENCE_ID RETURN_REFERENCE_ID
, LINK_TO_LINE_ID LINK_TO_LINE_ID
, RMA_HEADER_ID RMA_HEADER_ID
, RMA_NUMBER RMA_NUMBER
, RMA_INVENTORY_ITEM_ID RMA_INVENTORY_ITEM_ID
, RMA_LINE_ID RMA_LINE_ID
, RMA_LINE_NUMBER RMA_LINE_NUMBER
, RMA_ORGANIZATION_ID RMA_ORGANIZATION_ID
, RMA_LINE_TYPE_CODE RMA_LINE_TYPE_CODE
, RMA_SHIP_TO_SITE_USE_ID RMA_SHIP_TO_SITE_USE_ID
, RMA_INVOICE_INVENTORY_ITEM_ID RMA_INVOICE_INVENTORY_ITEM_ID
, CR_TRX_ID CR_TRX_ID
, CR_TRX_LINE_ID CR_TRX_LINE_ID
, PERIOD_NAME_YEAR PERIOD_NAME_YEAR
, PERIOD_NUM_YEAR PERIOD_NUM_YEAR
, PERIOD_NAME_QTR PERIOD_NAME_QTR
, PERIOD_NUM_QTR PERIOD_NUM_QTR
, PERIOD_SEQ_QTR PERIOD_SEQ_QTR
, PERIOD_NAME_MONTH PERIOD_NAME_MONTH
, PERIOD_NUM_MONTH PERIOD_NUM_MONTH
, PERIOD_SEQ_MONTH PERIOD_SEQ_MONTH
, OE_ITEM_CATEGORY_ID OE_ITEM_CATEGORY_ID
, AREA_CODE AREA_CODE
, COUNTRY_CODE COUNTRY_CODE
, REGION_CODE REGION_CODE
, AREA_NAME AREA_NAME
, COUNTRY_NAME COUNTRY_NAME
, REGION_NAME REGION_NAME
, OPERATING_UNIT_NAME OPERATING_UNIT_NAME
, MARGIN_PK MARGIN_PK
FROM "BOM"."CST_BIS_MARGIN_SUMMARY"