Product: | ICX - Oracle iProcurement |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT L.LEAD_ID
, L.LEAD_NUMBER
, L.DESCRIPTION
, L.STATUS
, L.CUSTOMER_ID
, L.ADDRESS_ID
, L.INITIATING_CONTACT_ID
, L.ORG_ID
, L.PRICE_LIST_ID
, LINE.LEAD_LINE_ID
, LINE.INTEREST_TYPE_ID
, LINE.PRIMARY_INTEREST_CODE_ID
, LINE.SECONDARY_INTEREST_CODE_ID
, NVL(INT.INTEREST_TYPE
, '') || '/' || NVL(PIC.CODE
, '') || '/' || NVL(SIC.CODE
, '')
, LINE.INVENTORY_ITEM_ID
, ITEM.CONCATENATED_SEGMENTS
, LINE.ORGANIZATION_ID
, LINE.UOM_CODE
, UOM.UNIT_OF_MEASURE
, LINE.QUANTITY
FROM AS_LEADS L
, AS_LEAD_LINES LINE
, MTL_UNITS_OF_MEASURE UOM
, MTL_SYSTEM_ITEMS_KFV ITEM
, AS_INTEREST_TYPES INT
, AS_INTEREST_CODES PIC
, AS_INTEREST_CODES SIC
WHERE L.LEAD_ID (+) = LINE.LEAD_ID
AND UOM.UOM_CODE (+) = LINE.UOM_CODE
AND ITEM.INVENTORY_ITEM_ID (+) = LINE.INVENTORY_ITEM_ID
AND ITEM.ORGANIZATION_ID (+) = LINE.ORGANIZATION_ID
AND INT.INTEREST_TYPE_ID (+) = LINE.INTEREST_TYPE_ID
AND PIC.INTEREST_CODE_ID (+) = LINE.PRIMARY_INTEREST_CODE_ID
AND SIC.INTEREST_CODE_ID (+) = LINE.SECONDARY_INTEREST_CODE_ID