View: AST_SALES_LEAD_LINES_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_SALES_LEAD_LINES_V

View Text

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.INTEREST_TYPE_ID
, LL.PRIMARY_INTEREST_CODE_ID
, LL.SECONDARY_INTEREST_CODE_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.CONCAT_CAT_PARENTAGE
, LL.CATEGORY_ID
, LL.CATEGORY_SET_ID
, LL.SOURCE_PROMOTION_ID
, AMSS.SOURCE_CODE
, LL.OFFER_ID
, AMSSOFR.SOURCE_CODE
, MTLUOM.UNIT_OF_MEASURE_TL
, MTLSI.CONCATENATED_SEGMENTS
, MTLSI.DESCRIPTION
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.CATEGORY_ID = DENORM.CATEGORY_ID
AND LL.CATEGORY_SET_ID = DENORM.CATEGORY_SET_ID
AND DENORM.LANGUAGE = USERENV('LANG')
AND DENORM.PURCHASE_INTEREST = 'Y'
AND 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(+)

Columns