Product: | AS - Sales Foundation |
---|---|
Description: | sales lead line foreign keys |
Implementation/DBA Data: | APPS.AS_SALES_LEAD_LINES_V |
SELECT LEAD_LINE.ROWID ROW_ID
, LEAD_LINE.SALES_LEAD_LINE_ID
, LEAD_LINE.LAST_UPDATE_DATE
, LEAD_LINE.LAST_UPDATED_BY
, LEAD_LINE.CREATION_DATE
, LEAD_LINE.CREATED_BY
, LEAD_LINE.LAST_UPDATE_LOGIN
, LEAD_LINE.REQUEST_ID
, LEAD_LINE.PROGRAM_APPLICATION_ID
, LEAD_LINE.PROGRAM_ID
, LEAD_LINE.PROGRAM_UPDATE_DATE
, LEAD_LINE.SALES_LEAD_ID
, LEAD_LINE.STATUS_CODE
, LEAD_LINE.INTEREST_TYPE_ID
, INTEREST.INTEREST_TYPE
, LEAD_LINE.PRIMARY_INTEREST_CODE_ID
, PRIMARY_CODE.CODE PRIMARY_INTEREST_CODE
, LEAD_LINE.SECONDARY_INTEREST_CODE_ID
, SECONDARY_CODE.CODE SECONDARY_INTEREST_CODE
, LEAD_LINE.INVENTORY_ITEM_ID
, LEAD_LINE.ORGANIZATION_ID
, LEAD_LINE.UOM_CODE
, LEAD_LINE.QUANTITY
, LEAD_LINE.BUDGET_AMOUNT
, LEAD_LINE.ATTRIBUTE_CATEGORY
, LEAD_LINE.ATTRIBUTE1
, LEAD_LINE.ATTRIBUTE2
, LEAD_LINE.ATTRIBUTE3
, LEAD_LINE.ATTRIBUTE4
, LEAD_LINE.ATTRIBUTE5
, LEAD_LINE.ATTRIBUTE6
, LEAD_LINE.ATTRIBUTE7
, LEAD_LINE.ATTRIBUTE8
, LEAD_LINE.ATTRIBUTE9
, LEAD_LINE.ATTRIBUTE10
, LEAD_LINE.ATTRIBUTE11
, LEAD_LINE.ATTRIBUTE12
, LEAD_LINE.ATTRIBUTE13
, LEAD_LINE.ATTRIBUTE14
, LEAD_LINE.ATTRIBUTE15
, LEAD_LINE.OFFER_ID
, AMS2.NAME OFFER_NAME
, AMS2.SOURCE_CODE OFFER_CODE
, LEAD_LINE.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
, INTEREST.DESCRIPTION
, PRIMARY_CODE.DESCRIPTION
, SECONDARY_CODE.DESCRIPTION
FROM AS_SALES_LEAD_LINES LEAD_LINE
, MTL_SYSTEM_ITEMS_B_KFV MTLSI
, AMS_P_SOURCE_CODES_V AMS1
, MTL_UNITS_OF_MEASURE_TL MTLUOM
, AMS_P_SOURCE_CODES_V AMS2
, AS_INTEREST_TYPES_TL INTEREST
, AS_INTEREST_CODES_TL PRIMARY_CODE
, AS_INTEREST_CODES_TL SECONDARY_CODE
WHERE LEAD_LINE.INVENTORY_ITEM_ID = MTLSI.INVENTORY_ITEM_ID(+)
AND LEAD_LINE.ORGANIZATION_ID = MTLSI.ORGANIZATION_ID(+)
AND LEAD_LINE.INTEREST_TYPE_ID = INTEREST.INTEREST_TYPE_ID(+)
AND INTEREST.LANGUAGE(+) = USERENV('LANG')
AND LEAD_LINE.PRIMARY_INTEREST_CODE_ID = PRIMARY_CODE.INTEREST_CODE_ID(+)
AND PRIMARY_CODE.LANGUAGE(+) = USERENV('LANG')
AND LEAD_LINE.SECONDARY_INTEREST_CODE_ID = SECONDARY_CODE.INTEREST_CODE_ID(+)
AND SECONDARY_CODE.LANGUAGE(+) = USERENV('LANG')
AND LEAD_LINE.SOURCE_PROMOTION_ID = AMS1.SOURCE_CODE_ID(+)
AND LEAD_LINE.UOM_CODE = MTLUOM.UOM_CODE(+)
AND MTLUOM.LANGUAGE(+) = USERENV('LANG')
AND LEAD_LINE.OFFER_ID = AMS2.SOURCE_CODE_ID(+)