Product: | AS - Sales Foundation |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AS_OPPORTUNITY_LINES_V |
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
, P.CONCAT_CAT_PARENTAGE 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
, MTLUOM.UNIT_OF_MEASURE_TL
, 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
, MTL_UNITS_OF_MEASURE_TL MTLUOM
, 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.UOM_CODE = MTLUOM.UOM_CODE(+)
AND MTLUOM.LANGUAGE(+) = USERENV('LANG')
AND OPPL.OFFER_ID = AMS2.SOURCE_CODE_ID(+)