View: ONT_PRT_CST_MARGIN_SUMMARY_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.ONT_PRT_CST_MARGIN_SUMMARY_V

View Text

SELECT CMS.BUILD_ID
, CMS.SOURCE
, CMS.ROW_TYPE
, CMS.ORIGIN
, CMS.INVOICE_SOURCE
, CMS.PARENT_ROWID
, CMS.ORDER_NUMBER
, CMS.ORG_ID
, CMS.HEADER_ID
, CMS.ORDER_TYPE_ID
, CMS.CUSTOMER_ID
, CMS.SOLD_TO_CUSTOMER_NAME
, CMS.PRIMARY_SALESREP_ID
, CMS.SALES_CHANNEL_CODE
, CMS.PARENT_INVENTORY_ITEM_ID
, CMS.PARENT_ORGANIZATION_ID
, CMS.PARENT_LINE_ID
, CMS.PARENT_LINE_NUMBER
, CMS.PARENT_ITEM_TYPE_CODE
, CMS.PARENT_ATO_FLAG
, CMS.INVENTORY_ITEM_ID
, CMS.ORGANIZATION_ID
, CMS.LINE_ID
, CMS.LINE_TYPE_CODE
, CMS.LINE_NUMBER
, CMS.SHIP_TO_SITE_USE_ID
, CMS.SHIP_TO_CUSTOMER_NAME
, CMS.INVOICE_TO_SITE_USE_ID
, CMS.BILL_TO_CUSTOMER_NAME
, CMS.CUSTOMER_TRX_ID
, CMS.CUSTOMER_TRX_LINE_ID
, CMS.ORIGINAL_GL_DATE
, CMS.GL_DATE
, CMS.INVOICE_LINE_QUANTITY
, CMS.INVOICE_QUANTITY
, CMS.ORDER_LINE_QUANTITY
, CMS.SHIP_QUANTITY
, CMS.INVOICED_AMOUNT
, CMS.COGS_AMOUNT
, CMS.SALES_ACCOUNT
, CMS.COGS_ACCOUNT
, CMS.TERRITORY_ID
, CMS.CUSTOMER_CLASS_CODE
, CMS.MARGIN
, CMS.MARGIN_PCT
, CMS.RETURN_REFERENCE_TYPE_CODE
, CMS.RETURN_REFERENCE_ID
, CMS.LINK_TO_LINE_ID
, CMS.RMA_HEADER_ID
, CMS.RMA_NUMBER
, CMS.RMA_INVENTORY_ITEM_ID
, CMS.RMA_LINE_ID
, CMS.RMA_LINE_NUMBER
, CMS.RMA_ORGANIZATION_ID
, CMS.RMA_LINE_TYPE_CODE
, CMS.RMA_SHIP_TO_SITE_USE_ID
, CMS.RMA_INVOICE_INVENTORY_ITEM_ID
, CMS.CR_TRX_ID
, CMS.CR_TRX_LINE_ID
FROM CST_MARGIN_SUMMARY CMS
, CST_MARGIN_BUILD CMB
WHERE CMS.BUILD_ID = CMB.BUILD_ID
AND CMS.GL_DATE >= CMB.TO_DATE - 90
AND CMS.BUILD_ID = (SELECT MAX(CMS.BUILD_ID)
FROM CST_MARGIN_SUMMARY)

Columns