VIEW: APPS.PA_BILL_RATES_V

Source

View Text - Preformatted

SELECT B.ROWID , B.BILL_RATE_SCH_ID , B.BILL_RATE_ORGANIZATION_ID , B.STD_BILL_RATE_SCHEDULE , B.PERSON_ID , P.FULL_NAME , Decode(P.Current_NPW_Flag, 'Y', P.NPW_Number, P.EMPLOYEE_NUMBER) , B.JOB_ID , NULL , B.EXPENDITURE_TYPE , B.NON_LABOR_RESOURCE , NULL , NULL , NULL , B.RATE , L.MEANING , B.BILL_RATE_UNIT , B.MARKUP_PERCENTAGE , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_LOGIN , B.JOB_GROUP_ID , B.Rate_Currency_Code , B.RESOURCE_CLASS_CODE , NULL , B.RES_CLASS_ORGANIZATION_ID FROM FND_LOOKUP_VALUES L, PER_PEOPLE_F P, PA_BILL_RATES B WHERE P.PERSON_ID = B.PERSON_ID AND P.EFFECTIVE_START_DATE = (SELECT MIN(PP.EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F PP WHERE PP.PERSON_ID = P.PERSON_ID AND PP.EFFECTIVE_END_DATE > SYSDATE) AND L.LOOKUP_TYPE = 'UNIT' AND L.LOOKUP_CODE = B.BILL_RATE_UNIT AND L.LANGUAGE = USERENV('LANG') AND L.VIEW_APPLICATION_ID = 275 UNION ALL SELECT B.ROWID, B.BILL_RATE_SCH_ID , B.BILL_RATE_ORGANIZATION_ID, B.STD_BILL_RATE_SCHEDULE, B.PERSON_ID, NULL, NULL, B.JOB_ID, J.NAME, B.EXPENDITURE_TYPE, B.NON_LABOR_RESOURCE, NULL, NULL, NULL, B.RATE, L.MEANING, B.BILL_RATE_UNIT, B.MARKUP_PERCENTAGE, B.START_DATE_ACTIVE, B.END_DATE_ACTIVE, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.JOB_GROUP_ID, B.Rate_Currency_Code, B.RESOURCE_CLASS_CODE, NULL, B.RES_CLASS_ORGANIZATION_ID FROM FND_LOOKUP_VALUES L, PER_JOBS J, PA_BILL_RATES B WHERE J.JOB_ID = B.JOB_ID AND L.LOOKUP_TYPE = 'UNIT' AND L.LOOKUP_CODE = B.BILL_RATE_UNIT AND L.LANGUAGE = USERENV('LANG') AND L.VIEW_APPLICATION_ID = 275 UNION ALL SELECT B.ROWID, B.BILL_RATE_SCH_ID, B.BILL_RATE_ORGANIZATION_ID, B.STD_BILL_RATE_SCHEDULE, B.PERSON_ID, NULL, NULL, B.JOB_ID, NULL, B.EXPENDITURE_TYPE, B.NON_LABOR_RESOURCE, ET.COST_RATE_FLAG, NULL, NULL, B.RATE, L.MEANING, B.BILL_RATE_UNIT, B.MARKUP_PERCENTAGE, B.START_DATE_ACTIVE, B.END_DATE_ACTIVE, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.JOB_GROUP_ID, B.Rate_Currency_Code, B.RESOURCE_CLASS_CODE, NULL, B.RES_CLASS_ORGANIZATION_ID FROM FND_LOOKUP_VALUES L, PA_EXPENDITURE_TYPES ET, PA_BILL_RATES B WHERE ET.EXPENDITURE_TYPE = B.EXPENDITURE_TYPE AND L.LOOKUP_TYPE = 'UNIT' AND L.LOOKUP_CODE = B.BILL_RATE_UNIT AND L.LANGUAGE = USERENV('LANG') AND L.VIEW_APPLICATION_ID = 275 UNION ALL SELECT B.ROWID, B.BILL_RATE_SCH_ID, B.BILL_RATE_ORGANIZATION_ID, B.STD_BILL_RATE_SCHEDULE, B.PERSON_ID, NULL, NULL, B.JOB_ID, NULL, B.EXPENDITURE_TYPE, B.NON_LABOR_RESOURCE, NULL, NULL, NULL, B.RATE, L.MEANING, B.BILL_RATE_UNIT, B.MARKUP_PERCENTAGE, B.START_DATE_ACTIVE, B.END_DATE_ACTIVE, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.JOB_GROUP_ID, B.Rate_Currency_Code, B.RESOURCE_CLASS_CODE, RES.name RESOURCE_CLASS, B.RES_CLASS_ORGANIZATION_ID FROM FND_LOOKUP_VALUES L, PA_resource_classes_vl RES, PA_BILL_RATES B WHERE RES.RESOURCE_CLASS_CODE = B.RESOURCE_CLASS_CODE AND L.LOOKUP_TYPE = 'UNIT' AND L.LOOKUP_CODE = B.BILL_RATE_UNIT AND L.LANGUAGE = USERENV('LANG') AND L.VIEW_APPLICATION_ID = 275

View Text - HTML Formatted

SELECT B.ROWID
, B.BILL_RATE_SCH_ID
, B.BILL_RATE_ORGANIZATION_ID
, B.STD_BILL_RATE_SCHEDULE
, B.PERSON_ID
, P.FULL_NAME
, DECODE(P.CURRENT_NPW_FLAG
, 'Y'
, P.NPW_NUMBER
, P.EMPLOYEE_NUMBER)
, B.JOB_ID
, NULL
, B.EXPENDITURE_TYPE
, B.NON_LABOR_RESOURCE
, NULL
, NULL
, NULL
, B.RATE
, L.MEANING
, B.BILL_RATE_UNIT
, B.MARKUP_PERCENTAGE
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.JOB_GROUP_ID
, B.RATE_CURRENCY_CODE
, B.RESOURCE_CLASS_CODE
, NULL
, B.RES_CLASS_ORGANIZATION_ID
FROM FND_LOOKUP_VALUES L
, PER_PEOPLE_F P
, PA_BILL_RATES B
WHERE P.PERSON_ID = B.PERSON_ID
AND P.EFFECTIVE_START_DATE = (SELECT MIN(PP.EFFECTIVE_START_DATE)
FROM PER_ALL_PEOPLE_F PP
WHERE PP.PERSON_ID = P.PERSON_ID
AND PP.EFFECTIVE_END_DATE > SYSDATE)
AND L.LOOKUP_TYPE = 'UNIT'
AND L.LOOKUP_CODE = B.BILL_RATE_UNIT
AND L.LANGUAGE = USERENV('LANG')
AND L.VIEW_APPLICATION_ID = 275 UNION ALL SELECT B.ROWID
, B.BILL_RATE_SCH_ID
, B.BILL_RATE_ORGANIZATION_ID
, B.STD_BILL_RATE_SCHEDULE
, B.PERSON_ID
, NULL
, NULL
, B.JOB_ID
, J.NAME
, B.EXPENDITURE_TYPE
, B.NON_LABOR_RESOURCE
, NULL
, NULL
, NULL
, B.RATE
, L.MEANING
, B.BILL_RATE_UNIT
, B.MARKUP_PERCENTAGE
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.JOB_GROUP_ID
, B.RATE_CURRENCY_CODE
, B.RESOURCE_CLASS_CODE
, NULL
, B.RES_CLASS_ORGANIZATION_ID
FROM FND_LOOKUP_VALUES L
, PER_JOBS J
, PA_BILL_RATES B
WHERE J.JOB_ID = B.JOB_ID
AND L.LOOKUP_TYPE = 'UNIT'
AND L.LOOKUP_CODE = B.BILL_RATE_UNIT
AND L.LANGUAGE = USERENV('LANG')
AND L.VIEW_APPLICATION_ID = 275 UNION ALL SELECT B.ROWID
, B.BILL_RATE_SCH_ID
, B.BILL_RATE_ORGANIZATION_ID
, B.STD_BILL_RATE_SCHEDULE
, B.PERSON_ID
, NULL
, NULL
, B.JOB_ID
, NULL
, B.EXPENDITURE_TYPE
, B.NON_LABOR_RESOURCE
, ET.COST_RATE_FLAG
, NULL
, NULL
, B.RATE
, L.MEANING
, B.BILL_RATE_UNIT
, B.MARKUP_PERCENTAGE
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.JOB_GROUP_ID
, B.RATE_CURRENCY_CODE
, B.RESOURCE_CLASS_CODE
, NULL
, B.RES_CLASS_ORGANIZATION_ID
FROM FND_LOOKUP_VALUES L
, PA_EXPENDITURE_TYPES ET
, PA_BILL_RATES B
WHERE ET.EXPENDITURE_TYPE = B.EXPENDITURE_TYPE
AND L.LOOKUP_TYPE = 'UNIT'
AND L.LOOKUP_CODE = B.BILL_RATE_UNIT
AND L.LANGUAGE = USERENV('LANG')
AND L.VIEW_APPLICATION_ID = 275 UNION ALL SELECT B.ROWID
, B.BILL_RATE_SCH_ID
, B.BILL_RATE_ORGANIZATION_ID
, B.STD_BILL_RATE_SCHEDULE
, B.PERSON_ID
, NULL
, NULL
, B.JOB_ID
, NULL
, B.EXPENDITURE_TYPE
, B.NON_LABOR_RESOURCE
, NULL
, NULL
, NULL
, B.RATE
, L.MEANING
, B.BILL_RATE_UNIT
, B.MARKUP_PERCENTAGE
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.JOB_GROUP_ID
, B.RATE_CURRENCY_CODE
, B.RESOURCE_CLASS_CODE
, RES.NAME RESOURCE_CLASS
, B.RES_CLASS_ORGANIZATION_ID
FROM FND_LOOKUP_VALUES L
, PA_RESOURCE_CLASSES_VL RES
, PA_BILL_RATES B
WHERE RES.RESOURCE_CLASS_CODE = B.RESOURCE_CLASS_CODE
AND L.LOOKUP_TYPE = 'UNIT'
AND L.LOOKUP_CODE = B.BILL_RATE_UNIT
AND L.LANGUAGE = USERENV('LANG')
AND L.VIEW_APPLICATION_ID = 275