SELECT CONCATENATED_SEGMENTS "invItem",
'DUMMY' "productDetail",
null "competitionDetail",
'DUMMY' "competition",
UOM_CODE "uom",
'DUMMY' "access",
QUANTITY "quantity",
UNIT_OF_MEASURE_TL "uomDesc",
SOURCE_PROMOTION_ID "campaignID",
CAMPAIGN_CODE "campaignCode",
TOTAL_AMOUNT "totalAmount",
'Y' "category",
OFFER_CODE "offerCode",
LEAD_ID "leadID",
OFFER_ID "offerID",
ITEM_DESCRIPTION "description",
INTEREST_TYPE ||
decode(PRIMARY_INTEREST_CODE,
null,
null,
'/' || PRIMARY_INTEREST_CODE) ||
decode(SECONDARY_INTEREST_CODE,
null,
null,
'/' || SECONDARY_INTEREST_CODE) "prodCatName",
INTEREST_TYPE_ID ||
decode(PRIMARY_INTEREST_CODE_ID,
null,
null,
'/' || PRIMARY_INTEREST_CODE_ID) ||
decode(SECONDARY_INTEREST_CODE_ID,
null,
null,
'/' || SECONDARY_INTEREST_CODE_ID) "prodCat",
NULL "productObjType",
LEAD_LINE_ID "leadLineID",
LAST_UPDATE_DATE "lastUpdateDate",
ORGANIZATION_ID "organizationID",
NULL "productCustomSetupID",
INVENTORY_ITEM_ID "invItemID",
NULL "productScenarioCode"
FROM AS_OPPORTUNITY_LINES_V lv
WHERE lv.INVENTORY_ITEM_ID in (
36177
,19513
,15539
,15541
)
