VIEW: APPS.ICX_CST_MARGIN_TEMP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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