Product: | OTA - Learning Management |
---|---|
Description: | View to list all information for Price list. |
Implementation/DBA Data: | APPS.OTA_PRICE_LISTS_V |
SELECT TPL.ROWID ROW_ID
, TPL.PRICE_LIST_ID
, TPL.BUSINESS_GROUP_ID
, TPL.NAME
, TPL.CURRENCY_CODE
, CUR.NAME CURRENCY_NAME
, TPL.DEFAULT_FLAG
, DF_LOOK.MEANING DEFAULT_FLAG_MEANING
, TPL.PRICE_LIST_TYPE
, PLT_LOOK.MEANING PRICE_LIST_TYPE_MEANING
, TPL.START_DATE
, TPL.END_DATE
, TPL.COMMENTS
, TPL.DESCRIPTION
, TPL.SINGLE_UNIT_PRICE
, TPL.TRAINING_UNIT_TYPE
, HR_GENERAL.DECODE_FND_COMM_LOOKUP( 'TRAINING_UNIT'
, TPL.TRAINING_UNIT_TYPE) TRAINING_UNIT_TYPE_MEANING
, TPL_INFORMATION_CATEGORY
, TPL_INFORMATION1
, TPL_INFORMATION2
, TPL_INFORMATION3
, TPL_INFORMATION4
, TPL_INFORMATION5
, TPL_INFORMATION6
, TPL_INFORMATION7
, TPL_INFORMATION8
, TPL_INFORMATION9
, TPL_INFORMATION10
, TPL_INFORMATION11
, TPL_INFORMATION12
, TPL_INFORMATION13
, TPL_INFORMATION14
, TPL_INFORMATION15
, TPL_INFORMATION16
, TPL_INFORMATION17
, TPL_INFORMATION18
, TPL_INFORMATION19
, TPL_INFORMATION20
, TPL.OBJECT_VERSION_NUMBER
, TPL.LAST_UPDATE_DATE
, TPL.LAST_UPDATED_BY
, TPL.LAST_UPDATE_LOGIN
, TPL.CREATED_BY
, TPL.CREATION_DATE
FROM FND_CURRENCIES_VL CUR
, HR_LOOKUPS DF_LOOK
, HR_LOOKUPS PLT_LOOK
, OTA_PRICE_LISTS TPL
WHERE CUR.CURRENCY_CODE = TPL.CURRENCY_CODE
AND DF_LOOK.LOOKUP_TYPE = 'YES_NO'
AND DF_LOOK.LOOKUP_CODE = TPL.DEFAULT_FLAG
AND PLT_LOOK.LOOKUP_TYPE = 'PRICE_LIST_TYPE'
AND PLT_LOOK.LOOKUP_CODE = TPL.PRICE_LIST_TYPE