VIEW: APPS.AST_OPPORTUNITY_LINES_V

Source

View Text - Preformatted

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, HR.NAME Operating_unit 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, hr_operating_units HR 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(+) AND OPPL.ORG_ID = HR.ORGANIZATION_ID (+)

View Text - HTML Formatted

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
, HR.NAME OPERATING_UNIT
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
, HR_OPERATING_UNITS HR
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(+)
AND OPPL.ORG_ID = HR.ORGANIZATION_ID (+)