VIEW: APPS.AST_SALES_LEAD_LINES_PC_V

Source

View Text - Preformatted

SELECT LL.ROWID , LL.SALES_LEAD_LINE_ID , LL.LAST_UPDATE_DATE , LL.LAST_UPDATED_BY , LL.CREATION_DATE , LL.CREATED_BY , LL.LAST_UPDATE_LOGIN , LL.REQUEST_ID , LL.PROGRAM_APPLICATION_ID , LL.PROGRAM_ID , LL.PROGRAM_UPDATE_DATE , LL.SALES_LEAD_ID , LL.STATUS_CODE , LL.CATEGORY_ID , LL.INVENTORY_ITEM_ID , LL.ORGANIZATION_ID , LL.UOM_CODE , LL.QUANTITY , LL.BUDGET_AMOUNT , LL.ATTRIBUTE_CATEGORY , LL.ATTRIBUTE1 , LL.ATTRIBUTE2 , LL.ATTRIBUTE3 , LL.ATTRIBUTE4 , LL.ATTRIBUTE5 , LL.ATTRIBUTE6 , LL.ATTRIBUTE7 , LL.ATTRIBUTE8 , LL.ATTRIBUTE9 , LL.ATTRIBUTE10 , LL.ATTRIBUTE11 , LL.ATTRIBUTE12 , LL.ATTRIBUTE13 , LL.ATTRIBUTE14 , LL.ATTRIBUTE15 , DENORM.CATEGORY_DESC , LL.SOURCE_PROMOTION_ID , AMSS.SOURCE_CODE , LL.OFFER_ID , AMSSOFR.SOURCE_CODE , MTLUOM.UNIT_OF_MEASURE_TL , MTLSI.CONCATENATED_SEGMENTS , MTLSI.DESCRIPTION , DECODE(GREATEST(LENGTH(DENORM.CONCAT_CAT_PARENTAGE),2000),2000,DENORM.CONCAT_CAT_PARENTAGE, SUBSTR(DENORM.CONCAT_CAT_PARENTAGE,LENGTH(DENORM.CONCAT_CAT_PARENTAGE)-1999,2000)) , LL.CATEGORY_SET_ID FROM AS_SALES_LEAD_LINES LL , MTL_SYSTEM_ITEMS_VL MTLSI , AMS_SOURCE_CODES AMSS , AMS_SOURCE_CODES AMSSOFR , MTL_UNITS_OF_MEASURE MTLUOM , ENI_PROD_DEN_HRCHY_PARENTS_V DENORM WHERE LL.INVENTORY_ITEM_ID = MTLSI.INVENTORY_ITEM_ID(+) AND LL.ORGANIZATION_ID = MTLSI.ORGANIZATION_ID(+) AND LL.SOURCE_PROMOTION_ID = AMSS.SOURCE_CODE_ID(+) AND LL.UOM_CODE = MTLUOM.UOM_CODE(+) AND MTLUOM.LANGUAGE(+) = USERENV('LANG') AND LL.OFFER_ID = AMSSOFR.SOURCE_CODE_ID(+) AND LL.CATEGORY_ID = DENORM.CATEGORY_ID

View Text - HTML Formatted

SELECT LL.ROWID
, LL.SALES_LEAD_LINE_ID
, LL.LAST_UPDATE_DATE
, LL.LAST_UPDATED_BY
, LL.CREATION_DATE
, LL.CREATED_BY
, LL.LAST_UPDATE_LOGIN
, LL.REQUEST_ID
, LL.PROGRAM_APPLICATION_ID
, LL.PROGRAM_ID
, LL.PROGRAM_UPDATE_DATE
, LL.SALES_LEAD_ID
, LL.STATUS_CODE
, LL.CATEGORY_ID
, LL.INVENTORY_ITEM_ID
, LL.ORGANIZATION_ID
, LL.UOM_CODE
, LL.QUANTITY
, LL.BUDGET_AMOUNT
, LL.ATTRIBUTE_CATEGORY
, LL.ATTRIBUTE1
, LL.ATTRIBUTE2
, LL.ATTRIBUTE3
, LL.ATTRIBUTE4
, LL.ATTRIBUTE5
, LL.ATTRIBUTE6
, LL.ATTRIBUTE7
, LL.ATTRIBUTE8
, LL.ATTRIBUTE9
, LL.ATTRIBUTE10
, LL.ATTRIBUTE11
, LL.ATTRIBUTE12
, LL.ATTRIBUTE13
, LL.ATTRIBUTE14
, LL.ATTRIBUTE15
, DENORM.CATEGORY_DESC
, LL.SOURCE_PROMOTION_ID
, AMSS.SOURCE_CODE
, LL.OFFER_ID
, AMSSOFR.SOURCE_CODE
, MTLUOM.UNIT_OF_MEASURE_TL
, MTLSI.CONCATENATED_SEGMENTS
, MTLSI.DESCRIPTION
, DECODE(GREATEST(LENGTH(DENORM.CONCAT_CAT_PARENTAGE)
, 2000)
, 2000
, DENORM.CONCAT_CAT_PARENTAGE
, SUBSTR(DENORM.CONCAT_CAT_PARENTAGE
, LENGTH(DENORM.CONCAT_CAT_PARENTAGE)-1999
, 2000))
, LL.CATEGORY_SET_ID
FROM AS_SALES_LEAD_LINES LL
, MTL_SYSTEM_ITEMS_VL MTLSI
, AMS_SOURCE_CODES AMSS
, AMS_SOURCE_CODES AMSSOFR
, MTL_UNITS_OF_MEASURE MTLUOM
, ENI_PROD_DEN_HRCHY_PARENTS_V DENORM
WHERE LL.INVENTORY_ITEM_ID = MTLSI.INVENTORY_ITEM_ID(+)
AND LL.ORGANIZATION_ID = MTLSI.ORGANIZATION_ID(+)
AND LL.SOURCE_PROMOTION_ID = AMSS.SOURCE_CODE_ID(+)
AND LL.UOM_CODE = MTLUOM.UOM_CODE(+)
AND MTLUOM.LANGUAGE(+) = USERENV('LANG')
AND LL.OFFER_ID = AMSSOFR.SOURCE_CODE_ID(+)
AND LL.CATEGORY_ID = DENORM.CATEGORY_ID