VIEW: APPS.CS_COVERAGE_TXN_GROUPS_V

Source

View Text - Preformatted

SELECT CTG.ROWID ROW_ID , CTG.COVERAGE_TXN_GROUP_ID , CTG.COVERAGE_ID , CTG.BUSINESS_PROCESS_ID , CBP.NAME , CTG.OFFSET_DURATION , CTG.OFFSET_PERIOD , CTG.COVERAGE_START_DATE , CTG.COVERAGE_END_DATE , CTG.PRICE_LIST_ID , SOPL.NAME PRICE_LIST , CTG.DISCOUNT_ID , SOD.NAME DISCOUNT , CTG.SUNDAY_START_TIME , CTG.SUNDAY_END_TIME , CTG.MONDAY_START_TIME , CTG.MONDAY_END_TIME , CTG.TUESDAY_START_TIME , CTG.TUESDAY_END_TIME , CTG.WEDNESDAY_START_TIME , CTG.WEDNESDAY_END_TIME , CTG.THURSDAY_START_TIME , CTG.THURSDAY_END_TIME , CTG.FRIDAY_START_TIME , CTG.FRIDAY_END_TIME , CTG.SATURDAY_START_TIME , CTG.SATURDAY_END_TIME , CTG.TIME_ZONE_ID , CTZ.NAME TIME_ZONE , CTG.PREFERRED_ENGINEER1 , WFR1.DISPLAY_NAME PREFERRED_ENGINEER_NAME1 , CTG.PREFERRED_ENGINEER2 , WFR2.DISPLAY_NAME PREFERRED_ENGINEER_NAME2 , CTG.LAST_UPDATE_DATE , CTG.LAST_UPDATED_BY , CTG.CREATION_DATE , CTG.CREATED_BY , CTG.LAST_UPDATE_LOGIN , CTG.ATTRIBUTE1 , CTG.ATTRIBUTE2 , CTG.ATTRIBUTE3 , CTG.ATTRIBUTE4 , CTG.ATTRIBUTE5 , CTG.ATTRIBUTE6 , CTG.ATTRIBUTE7 , CTG.ATTRIBUTE8 , CTG.ATTRIBUTE9 , CTG.ATTRIBUTE10 , CTG.ATTRIBUTE11 , CTG.ATTRIBUTE12 , CTG.ATTRIBUTE13 , CTG.ATTRIBUTE14 , CTG.ATTRIBUTE15 , CTG.CONTEXT , CTG.OBJECT_VERSION_NUMBER FROM CS_COVERAGE_TXN_GROUPS CTG, CS_BUSINESS_PROCESSES CBP, SO_PRICE_LISTS SOPL, SO_DISCOUNTS SOD, CS_TIME_ZONES CTZ, WF_ROLES WFR1, WF_ROLES WFR2 WHERE CTG.BUSINESS_PROCESS_ID = CBP.BUSINESS_PROCESS_ID AND CTG.PRICE_LIST_ID = SOPL.PRICE_LIST_ID(+) AND CTG.DISCOUNT_ID = SOD.DISCOUNT_ID(+) AND CTG.TIME_ZONE_ID = CTZ.TIME_ZONE_ID(+) AND CTG.PREFERRED_ENGINEER1 = WFR1.NAME(+) AND CTG.PREFERRED_ENGINEER2 = WFR2.NAME(+)

View Text - HTML Formatted

SELECT CTG.ROWID ROW_ID
, CTG.COVERAGE_TXN_GROUP_ID
, CTG.COVERAGE_ID
, CTG.BUSINESS_PROCESS_ID
, CBP.NAME
, CTG.OFFSET_DURATION
, CTG.OFFSET_PERIOD
, CTG.COVERAGE_START_DATE
, CTG.COVERAGE_END_DATE
, CTG.PRICE_LIST_ID
, SOPL.NAME PRICE_LIST
, CTG.DISCOUNT_ID
, SOD.NAME DISCOUNT
, CTG.SUNDAY_START_TIME
, CTG.SUNDAY_END_TIME
, CTG.MONDAY_START_TIME
, CTG.MONDAY_END_TIME
, CTG.TUESDAY_START_TIME
, CTG.TUESDAY_END_TIME
, CTG.WEDNESDAY_START_TIME
, CTG.WEDNESDAY_END_TIME
, CTG.THURSDAY_START_TIME
, CTG.THURSDAY_END_TIME
, CTG.FRIDAY_START_TIME
, CTG.FRIDAY_END_TIME
, CTG.SATURDAY_START_TIME
, CTG.SATURDAY_END_TIME
, CTG.TIME_ZONE_ID
, CTZ.NAME TIME_ZONE
, CTG.PREFERRED_ENGINEER1
, WFR1.DISPLAY_NAME PREFERRED_ENGINEER_NAME1
, CTG.PREFERRED_ENGINEER2
, WFR2.DISPLAY_NAME PREFERRED_ENGINEER_NAME2
, CTG.LAST_UPDATE_DATE
, CTG.LAST_UPDATED_BY
, CTG.CREATION_DATE
, CTG.CREATED_BY
, CTG.LAST_UPDATE_LOGIN
, CTG.ATTRIBUTE1
, CTG.ATTRIBUTE2
, CTG.ATTRIBUTE3
, CTG.ATTRIBUTE4
, CTG.ATTRIBUTE5
, CTG.ATTRIBUTE6
, CTG.ATTRIBUTE7
, CTG.ATTRIBUTE8
, CTG.ATTRIBUTE9
, CTG.ATTRIBUTE10
, CTG.ATTRIBUTE11
, CTG.ATTRIBUTE12
, CTG.ATTRIBUTE13
, CTG.ATTRIBUTE14
, CTG.ATTRIBUTE15
, CTG.CONTEXT
, CTG.OBJECT_VERSION_NUMBER
FROM CS_COVERAGE_TXN_GROUPS CTG
, CS_BUSINESS_PROCESSES CBP
, SO_PRICE_LISTS SOPL
, SO_DISCOUNTS SOD
, CS_TIME_ZONES CTZ
, WF_ROLES WFR1
, WF_ROLES WFR2
WHERE CTG.BUSINESS_PROCESS_ID = CBP.BUSINESS_PROCESS_ID
AND CTG.PRICE_LIST_ID = SOPL.PRICE_LIST_ID(+)
AND CTG.DISCOUNT_ID = SOD.DISCOUNT_ID(+)
AND CTG.TIME_ZONE_ID = CTZ.TIME_ZONE_ID(+)
AND CTG.PREFERRED_ENGINEER1 = WFR1.NAME(+)
AND CTG.PREFERRED_ENGINEER2 = WFR2.NAME(+)