VIEW: APPS.AST_SALES_LEAD_LINES_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.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(+)

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.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(+)