Product: | PA - Projects |
---|---|
Description: | This view is in period close reports. It shows the details of all cross charge distribution lines that prevent closing a period |
Implementation/DBA Data: | APPS.PA_CC_EXCEPTIONS_DET_V |
SELECT PSV.PROJECT_ID PROJECT_ID
, PSV.PROJECT_NUMBER PROJECT_NUMBER
, PSV.TASK_ID TASK_ID
, PT.TASK_NUMBER
, PSV.RECVR_ORG_ID RECVR_ORG_ID
, PSV.RECVR_ORG_NAME RECVR_ORG_NAME
, PSV.EMPLOYEE_ID
, PF.FULL_NAME EMPLOYEE_NAME
, PSV.VENDOR_ID VENDOR_ID
, PV.VENDOR_NAME VENDOR_NAME
, PSV.NON_LABOR_ORG_ID NON_LABOR_ORG_ID
, OTL1.NAME NON_LABOR_ORG_NAME
, PSV.EXPND_ORG_ID EXPND_ORG_ID
, OTL2.NAME EXPND_ORG_NAME
, PSV.EXPENDITURE_ID
, PSV.EXPENDITURE_ITEM_ID
, PSV.EXPENDITURE_ITEM_DATE
, PSV.EXPENDITURE_TYPE
, PSV.CDL_LINE_NUM
, PSV.PA_DATE
, PSV.PERIOD_NAME
, PSV.ACCT_CURRENCY_CODE
, PSV.AMOUNT
, PSV.EXCEPTION_REASON
, PSV.CORRECTIVE_ACTION
, PSV.EXCEPTION_CODE
, PSV.SYSTEM_LINKAGE_FUNCTION
FROM PA_CC_EXCEPTIONS_SUM_V PSV
, PA_TASKS PT
, PER_PEOPLE_F PF
, PO_VENDORS PV
, HR_ALL_ORGANIZATION_UNITS_TL OTL1
, HR_ALL_ORGANIZATION_UNITS_TL OTL2
WHERE PSV.TASK_ID=PT.TASK_ID
AND PSV.EMPLOYEE_ID=PF.PERSON_ID(+)
AND PSV.VENDOR_ID=PV.VENDOR_ID(+)
AND PSV.NON_LABOR_ORG_ID=OTL1.ORGANIZATION_ID(+)
AND DECODE(OTL1.ORGANIZATION_ID
, NULL
, '1'
, OTL1.LANGUAGE)= DECODE(OTL1.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND PSV.EXPND_ORG_ID=OTL2.ORGANIZATION_ID(+)
AND DECODE(OTL2.ORGANIZATION_ID
, NULL
, '1'
, OTL2.LANGUAGE)= DECODE(OTL2.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))