Product: | OKS - Service Contracts |
---|---|
Description: | Billing Rates View For Service Contracts |
Implementation/DBA Data: | APPS.OKS_ENT_BILL_RATES_V |
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