View: PA_NLR_ORGANIZATIONS_RES_V

Product:	PA - Projects
Description:	10Sc Only
Implementation/DBA Data:	APPS.PA_NLR_ORGANIZATIONS_RES_V

View Text

SELECT NLR.NON_LABOR_RESOURCE_ID
, NLR_ORG.NON_LABOR_RESOURCE
, NLR.EXPENDITURE_TYPE
, NLR_ORG.ORGANIZATION_ID
, SUBSTR(ORG.NAME
, 1
, 60)
, 'N'
, NULL
, 'N'
, NVL(NLR.EQUIPMENT_RESOURCE_FLAG
, 'N')
FROM PA_NON_LABOR_RESOURCE_ORGS NLR_ORG
, HR_ORGANIZATION_UNITS ORG
, PA_NON_LABOR_RESOURCES_RES_V NLR
WHERE DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES
, 'Y'
, NLR_ORG.START_DATE_ACTIVE
, TRUNC(SYSDATE) ) BETWEEN NLR_ORG.START_DATE_ACTIVE
AND NVL(NLR_ORG.END_DATE_ACTIVE
, TRUNC(SYSDATE))
AND DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES
, 'Y'
, ORG.DATE_FROM
, TRUNC(SYSDATE) ) BETWEEN ORG.DATE_FROM
AND NVL(ORG.DATE_TO
, TRUNC(SYSDATE))
AND NLR_ORG.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND NLR_ORG.NON_LABOR_RESOURCE = NLR.NON_LABOR_RESOURCE

Columns