VIEW: APPS.PA_BOM_LABOR_RES_V

Source

View Text - Preformatted

SELECT b.resource_id, b.resource_code, b.description, o.name Organization_Name from bom_resources b, hr_all_organization_units_vl o WHERE b.resource_type = 2 and b.organization_id = o.organization_id and nvl(b.disable_date, sysdate) >= sysdate and b.EXPENDITURE_TYPE is not null

View Text - HTML Formatted

SELECT B.RESOURCE_ID
, B.RESOURCE_CODE
, B.DESCRIPTION
, O.NAME ORGANIZATION_NAME
FROM BOM_RESOURCES B
, HR_ALL_ORGANIZATION_UNITS_VL O
WHERE B.RESOURCE_TYPE = 2
AND B.ORGANIZATION_ID = O.ORGANIZATION_ID
AND NVL(B.DISABLE_DATE
, SYSDATE) >= SYSDATE
AND B.EXPENDITURE_TYPE IS NOT NULL