VIEW: APPS.OKS_ENT_BILL_RATES_V

Source

View Text - Preformatted

SELECT KL.ID BILL_RATE_ID ,KL.CLE_ID BILLING_TYPE_ID ,BSC.BILL_RATE_CODE RATE_CODE ,OKS_ENT_UTIL_PVT.get_billrate(BSC.BILL_RATE_CODE) RATE_NAME ,BSC.UOM RATE_UOM ,BSC.FLAT_RATE RATE_AMOUNT ,BSC.PERCENT_OVER_LIST_PRICE RATE_PERCENT ,TO_NUMBER(BSC.OBJECT1_ID1) LABOR_ITEM_ID ,TO_NUMBER(BSC.OBJECT1_ID2) INV_ORGANIZATION_ID ,LPAD(TO_CHAR(BSC.START_HOUR), 2, '0')|| decode(BSC.START_HOUR,NULL,decode(BSC.START_MINUTE,NULL,'',':'),':') || LPAD(TO_CHAR(BSC.START_MINUTE), 2, '0') SCH_START ,LPAD(TO_CHAR(BSC.END_HOUR), 2, '0') || decode(BSC.END_HOUR,NULL,decode(BSC.END_MINUTE,NULL,'',':'),':') || LPAD(TO_CHAR(BSC.END_MINUTE), 2, '0') SCH_END ,nvl(BSC.SUNDAY_FLAG,'N') SCH_FOR_SUNDAY ,nvl(BSC.MONDAY_FLAG,'N') SCH_FOR_MONDAY ,nvl(BSC.TUESDAY_FLAG,'N') SCH_FOR_TUESDAY ,nvl(BSC.WEDNESDAY_FLAG,'N') SCH_FOR_WEDNESDAY ,nvl(BSC.THURSDAY_FLAG,'N') SCH_FOR_THURSDAY ,nvl(BSC.FRIDAY_FLAG,'N') SCH_FOR_FRIDAY ,nvl(BSC.SATURDAY_FLAG,'N') SCH_FOR_SATURDAY ,nvl(BSC.HOLIDAY_YN,'N') SCH_FOR_HOLIDAY FROM OKC_K_LINES_B KL ,OKS_BILLRATE_SCHEDULES BSC WHERE KL.LSE_ID in (6,24,60) AND KL.ID = BSC.CLE_ID

View Text - HTML Formatted

SELECT KL.ID BILL_RATE_ID
, KL.CLE_ID BILLING_TYPE_ID
, BSC.BILL_RATE_CODE RATE_CODE
, OKS_ENT_UTIL_PVT.GET_BILLRATE(BSC.BILL_RATE_CODE) RATE_NAME
, BSC.UOM RATE_UOM
, BSC.FLAT_RATE RATE_AMOUNT
, BSC.PERCENT_OVER_LIST_PRICE RATE_PERCENT
, TO_NUMBER(BSC.OBJECT1_ID1) LABOR_ITEM_ID
, TO_NUMBER(BSC.OBJECT1_ID2) INV_ORGANIZATION_ID
, LPAD(TO_CHAR(BSC.START_HOUR)
, 2
, '0')|| DECODE(BSC.START_HOUR
, NULL
, DECODE(BSC.START_MINUTE
, NULL
, ''
, ':')
, ':') || LPAD(TO_CHAR(BSC.START_MINUTE)
, 2
, '0') SCH_START
, LPAD(TO_CHAR(BSC.END_HOUR)
, 2
, '0') || DECODE(BSC.END_HOUR
, NULL
, DECODE(BSC.END_MINUTE
, NULL
, ''
, ':')
, ':') || LPAD(TO_CHAR(BSC.END_MINUTE)
, 2
, '0') SCH_END
, NVL(BSC.SUNDAY_FLAG
, 'N') SCH_FOR_SUNDAY
, NVL(BSC.MONDAY_FLAG
, 'N') SCH_FOR_MONDAY
, NVL(BSC.TUESDAY_FLAG
, 'N') SCH_FOR_TUESDAY
, NVL(BSC.WEDNESDAY_FLAG
, 'N') SCH_FOR_WEDNESDAY
, NVL(BSC.THURSDAY_FLAG
, 'N') SCH_FOR_THURSDAY
, NVL(BSC.FRIDAY_FLAG
, 'N') SCH_FOR_FRIDAY
, NVL(BSC.SATURDAY_FLAG
, 'N') SCH_FOR_SATURDAY
, NVL(BSC.HOLIDAY_YN
, 'N') SCH_FOR_HOLIDAY
FROM OKC_K_LINES_B KL
, OKS_BILLRATE_SCHEDULES BSC
WHERE KL.LSE_ID IN (6
, 24
, 60)
AND KL.ID = BSC.CLE_ID