1. Tables and Views for Project Management
  2. PJC_LABOR_COSTS_TOTAL_ERRORS_V

PJC_LABOR_COSTS_TOTAL_ERRORS_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

ROW_KEY

ERROR_COUNT

ERROR_AMOUNT

BU_ID

BUSINESS_UNIT_NAME

Query

SQL_Statement

SELECT ROWNUM AS ROW_KEY,

ERROR_COUNT,

ERROR_AMOUNT,

BU_ID,

BUSINESS_UNIT_NAME

FROM(

SELECT

COUNT(DISTINCT ProjectAllocTxnPEO.LD_INTERFACE_ID) AS ERROR_COUNT,

SUM(ProjectAllocTxnPEO.TOTAL_POOL_AMOUNT) AS ERROR_AMOUNT,

ProjectAllocTxnPEO.ORG_ID AS BU_ID,

Organizations.NAME AS BUSINESS_UNIT_NAME

FROM PJC_ALLOC_RUNS_ALL ProjectAllocTxnPEO,

HR_ORGANIZATION_UNITS_F_TL Organizations

WHERE ProjectAllocTxnPEO.ORG_ID = Organizations.ORGANIZATION_ID

AND Organizations.LANGUAGE = USERENV('LANG')

AND TRUNC(SYSDATE) BETWEEN Organizations.EFFECTIVE_START_DATE AND Organizations.EFFECTIVE_END_DATE

AND ProjectAllocTxnPEO.RUN_STATUS = 'RF'

AND ProjectAllocTxnPEO.LD_ORIG_TRANSACTION_REFERENCE IS NOT NULL

GROUP BY ProjectAllocTxnPEO.ORG_ID, Organizations.NAME

)