View: AST_OPPORTUNITY_LINES_V

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

View Text

SELECT OPPL.ROWID ROW_ID
, OPPL.LEAD_LINE_ID
, OPPL.LAST_UPDATE_DATE
, OPPL.LAST_UPDATED_BY
, OPPL.CREATION_DATE
, OPPL.CREATED_BY
, OPPL.LAST_UPDATE_LOGIN
, OPPL.REQUEST_ID
, OPPL.PROGRAM_APPLICATION_ID
, OPPL.PROGRAM_ID
, OPPL.PROGRAM_UPDATE_DATE
, OPPL.LEAD_ID
, OPPL.PRODUCT_CATEGORY_ID
, OPPL.PRODUCT_CAT_SET_ID
, NVL(P.CONCAT_CAT_PARENTAGE
, OPPL.PRODUCT_CATEGORY_ID) CONCATENATED_CAT_DESC
, OPPL.INTEREST_STATUS_CODE
, OPPL.INVENTORY_ITEM_ID
, OPPL.ORGANIZATION_ID
, OPPL.UOM_CODE
, OPPL.QUANTITY
, OPPL.TOTAL_AMOUNT
, OPPL.SHIP_DATE
, OPPL.ORIGINAL_LEAD_LINE_ID
, OPPL.QUOTED_LINE_FLAG
, OPPL.ORG_ID
, OPPL.FORECAST_DATE
, OPPL.ROLLING_FORECAST_FLAG
, OPPL.PRICE
, OPPL.PRICE_VOLUME_MARGIN
, OPPL.ATTRIBUTE_CATEGORY
, OPPL.ATTRIBUTE1
, OPPL.ATTRIBUTE2
, OPPL.ATTRIBUTE3
, OPPL.ATTRIBUTE4
, OPPL.ATTRIBUTE5
, OPPL.ATTRIBUTE6
, OPPL.ATTRIBUTE7
, OPPL.ATTRIBUTE8
, OPPL.ATTRIBUTE9
, OPPL.ATTRIBUTE10
, OPPL.ATTRIBUTE11
, OPPL.ATTRIBUTE12
, OPPL.ATTRIBUTE13
, OPPL.ATTRIBUTE14
, OPPL.ATTRIBUTE15
, OPPL.OFFER_ID
, AMS2.NAME OFFER_NAME
, AMS2.SOURCE_CODE OFFER_CODE
, OPPL.SOURCE_PROMOTION_ID
, AMS1.NAME CAMPAIGN_NAME
, AMS1.OBJECT_ID CAMPAIGN_ID
, AMS1.SOURCE_CODE CAMPAIGN_CODE
, AMS1.SOURCE_CODE SOURCE_CODE
, MTLSI.CONCATENATED_SEGMENTS
, MTLSI.DESCRIPTION ITEM_DESCRIPTION
, P.DISABLE_DATE
, P.PURCHASE_INTEREST
FROM AS_LEAD_LINES_ALL OPPL
, MTL_SYSTEM_ITEMS_B_KFV MTLSI
, AMS_P_SOURCE_CODES_V AMS1
, AMS_P_SOURCE_CODES_V AMS2
, ENI_PROD_DEN_HRCHY_PARENTS_V P
WHERE OPPL.INVENTORY_ITEM_ID = MTLSI.INVENTORY_ITEM_ID(+)
AND OPPL.ORGANIZATION_ID = MTLSI.ORGANIZATION_ID(+)
AND OPPL.PRODUCT_CATEGORY_ID = P.CATEGORY_ID(+)
AND OPPL.PRODUCT_CAT_SET_ID = P.CATEGORY_SET_ID(+)
AND P.LANGUAGE(+) = USERENV('LANG')
AND OPPL.SOURCE_PROMOTION_ID = AMS1.SOURCE_CODE_ID(+)
AND OPPL.OFFER_ID = AMS2.SOURCE_CODE_ID(+)

Columns