VIEW: APPS.PA_BILL_RATES_JOB

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, 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

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
, 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