[Home] [Help]
| Product: | ICX - Oracle iProcurement |
|---|---|
| Description: | Obsolete |
| Implementation/DBA Data: | Not implemented in this database |
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)