VIEW: APPS.PA_NLR_ORGANIZATIONS_RES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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