VIEW: APPS.OTA_PRICE_LISTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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