VIEW: APPS.ONT_PRT_CST_MARGIN_SUMMARY_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)