Product: | OKI - Contracts Intelligence (Obsolete) |
---|---|
Description: | Information about contracts with the sell intent. |
Implementation/DBA Data: | Not implemented in this database |
SELECT SHD.CHR_ID CONTRACT_ID
, SHD.CONTRACT_NUMBER
, SHD.CONTRACT_NUMBER_MODIFIER
, SHD.COMPLETE_CONTRACT_NUMBER
, SHD.AUTHORING_ORG_ID
, SHD.ORGANIZATION_NAME
, SHD.SCS_CODE CATEGORY_CODE
, SCS.MEANING CATEGORY_MEANING
, SHD.STS_CODE STATUS_CODE
, STS.MEANING STATUS_MEANING
, STS.STE_CODE STATUS_TYPE_CODE
, STE.MEANING STATUS_TYPE_MEANING
, SHD.CUSTOMER_PARTY_ID
, SHD.CUSTOMER_NAME
, NVL(SHD.CONTRACT_AMOUNT
, 0) CONTRACT_AMOUNT
, NVL(SHD.FORECAST_AMOUNT
, 0) FORECAST_AMOUNT
, SHD.CURRENCY_CODE
, NVL(SHD.CONTRACT_AMOUNT_RENEWED
, 0) CONTRACT_AMOUNT_RENEWED
, SHD.CURRENCY_CODE_RENEWED
, NVL(SHD.SOB_CONTRACT_AMOUNT
, 0) SOB_CONTRACT_AMOUNT
, NVL(SHD.SOB_FORECAST_AMOUNT
, 0) SOB_FORECAST_AMOUNT
, NVL(SHD.SOB_CONTRACT_AMOUNT_RENEWED
, 0) SOB_CONTRACT_AMOUNT_RENEWED
, SHD.SOB_CURRENCY_CODE
, NVL(SHD.BASE_CONTRACT_AMOUNT
, 0) BASE_CONTRACT_AMOUNT
, NVL(SHD.BASE_FORECAST_AMOUNT
, 0) BASE_FORECAST_AMOUNT
, NVL(SHD.BASE_CONTRACT_AMOUNT_RENEWED
, 0) BASE_CONTRACT_AMOUNT_RENEWED
, SHD.BASE_CURRENCY_CODE
, SHD.WIN_PERCENT
, SHD.CLOSE_DATE EXPECTED_CLOSE_DATE
, SHD.START_DATE
, SHD.END_DATE
, SHD.DATE_APPROVED
, SHD.DATE_SIGNED
, SHD.DATE_RENEWED
, SHD.DATE_CANCELED
, SHD.DATE_TERMINATED
, SHD.START_PERIOD_NUM
, SHD.START_PERIOD_NAME
, SHD.START_QUARTER
, SHD.START_YEAR
, SHD.CLOSE_PERIOD_NUM
, SHD.CLOSE_PERIOD_NAME
, SHD.CLOSE_QUARTER
, SHD.CLOSE_YEAR
, SHD.TRN_CODE
, TRN.MEANING TERMINATION_MEANING
, SHD.INVENTORY_ORGANIZATION_ID
, SHD.APPLICATION_ID
, SHD.CREATION_DATE CREATION_DATE
, SHD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SHD.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SHD.ATTRIBUTE1 ATTRIBUTE1
, SHD.ATTRIBUTE1 ATTRIBUTE2
, SHD.ATTRIBUTE1 ATTRIBUTE3
, SHD.ATTRIBUTE1 ATTRIBUTE4
, SHD.ATTRIBUTE1 ATTRIBUTE5
, SHD.ATTRIBUTE1 ATTRIBUTE6
, SHD.ATTRIBUTE1 ATTRIBUTE7
, SHD.ATTRIBUTE1 ATTRIBUTE8
, SHD.ATTRIBUTE1 ATTRIBUTE9
, SHD.ATTRIBUTE1 ATTRIBUTE10
, SHD.ATTRIBUTE1 ATTRIBUTE11
, SHD.ATTRIBUTE1 ATTRIBUTE12
, SHD.ATTRIBUTE1 ATTRIBUTE13
, SHD.ATTRIBUTE1 ATTRIBUTE14
, SHD.ATTRIBUTE1 ATTRIBUTE15
FROM OKI_SALES_K_HDRS SHD
, OKC_SUBCLASSES_V SCS
, OKC_STATUSES_V STS
, FND_LOOKUPS STE
, FND_LOOKUPS TRN
WHERE SCS.CODE = SHD.SCS_CODE
AND STS.CODE = SHD.STS_CODE
AND STE.LOOKUP_CODE = SHD.STE_CODE
AND STE.LOOKUP_TYPE = 'OKC_STATUS_TYPE'
AND TRN.LOOKUP_CODE(+) = SHD.TRN_CODE
AND TRN.LOOKUP_TYPE(+) = 'OKC_TERMINATION_REASON'
AND OKC_UTIL.GET_K_ACCESS_LEVEL(SHD.CHR_ID
, SHD.SCS_CODE) IN ('R'
, 'U')