View: CST_BIS_MARGIN_ANALYSIS_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_BIS_MARGIN_ANALYSIS_V

View Text

SELECT NVL(MCV.CONCATENATED_SEGMENTS
, 'UNASSIGNED')
, MSIV.CONCATENATED_SEGMENTS
, MSI.PRIMARY_UOM_CODE
, CMB.LEGAL_ENTITY_NAME
, NVL(TEMP.OPERATING_UNIT_NAME
, 'UNASSIGNED')
, TEMP.ORDER_NUMBER
, TEMP.PARENT_LINE_NUMBER
, TEMP.GL_DATE
, NVL(SL.MEANING
, 'UNASSIGNED')
, NVL(HP.PARTY_NAME
, 'UNASSIGNED')
, NVL(RSA.NAME
, 'UNASSIGNED')
, NVL(AL.MEANING
, 'UNASSIGNED')
, NVL(RT.NAME
, 'UNASSIGNED')
, NVL(TEMP.AREA_NAME
, 'UNASSIGNED')
, NVL(TEMP.COUNTRY_NAME
, 'UNASSIGNED')
, NVL(TEMP.REGION_NAME
, 'UNASSIGNED')
, NVL(TEMP.PERIOD_NAME_YEAR
, 'UNASSIGNED')
, NVL(TEMP.PERIOD_NAME_QTR
, 'UNASSIGNED')
, NVL(TEMP.PERIOD_NAME_MONTH
, 'UNASSIGNED')
, TEMP.PERIOD_NUM_YEAR
, TEMP.PERIOD_NUM_QTR
, TEMP.PERIOD_NUM_MONTH
, DECODE( TEMP.PERIOD_NUM_QTR
, NULL
, 'UNASSIGNED'
, 'QUARTER ' || TEMP.PERIOD_NUM_QTR)
, DECODE(TEMP.PERIOD_NUM_MONTH
, 'UNASSIGNED'
, 'MONTH ' || TEMP.PERIOD_NUM_MONTH)
, TEMP.PERIOD_SEQ_QTR
, TEMP.PERIOD_SEQ_MONTH
, NVL(TEMP.INVOICE_QUANTITY
, 0)
, NVL(TEMP.SHIP_QUANTITY
, 0)
, NVL(TEMP.INVOICED_AMOUNT
, 0)
, NVL(TEMP.COGS_AMOUNT
, 0)
FROM MTL_CATEGORIES_KFV MCV
, MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS MSI
, MTL_SYSTEM_ITEMS_KFV MSIV
, SO_LOOKUPS SL
, RA_TERRITORIES RT
, AR_LOOKUPS AL
, RA_SALESREPS_ALL RSA
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HP
, CST_BIS_MARGIN_BUILD CMB
, CST_BIS_MARGIN_SUMMARY TEMP
WHERE TEMP.PARENT_ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = TEMP.PARENT_INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
AND SL.LOOKUP_TYPE (+) = 'SALES_CHANNEL'
AND SL.LOOKUP_CODE (+) = TEMP.SALES_CHANNEL_CODE
AND RT.TERRITORY_ID (+) = TEMP.TERRITORY_ID
AND AL.LOOKUP_TYPE (+) = 'CUSTOMER CLASS'
AND AL.LOOKUP_CODE (+) = TEMP.CUSTOMER_CLASS_CODE
AND RSA.SALESREP_ID (+) = TEMP.PRIMARY_SALESREP_ID
AND RSA.ORG_ID (+) = TEMP.ORG_ID
AND HCA.PARTY_ID = HP.PARTY_ID(+)
AND HCA.CUST_ACCOUNT_ID(+) = TEMP.CUSTOMER_ID
AND CMB.LEGAL_ENTITY_ID = TEMP.LEGAL_ENTITY_ID
AND MSI.INVENTORY_ITEM_ID = MSIV.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MSIV.ORGANIZATION_ID
AND TEMP.OE_ITEM_CATEGORY_ID= MCV.CATEGORY_ID (+)

Columns