View: PA_GL_CC_EXCEPT_DET_V

Product:	PA - Projects
Description:	Cross charge distributions in the primary set of books that prevent a period from being closed. This view is used in period close reports. It shows the details of all cross charge distribution lines in the primary set of books that preven
Implementation/DBA Data:	APPS.PA_GL_CC_EXCEPT_DET_V

View Text

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.GL_DATE
, PSV.PERIOD_NAME
, PSV.ACCT_CURRENCY_CODE
, PSV.AMOUNT
, PSV.EXCEPTION_REASON
, PSV.CORRECTIVE_ACTION
, PSV.EXCEPTION_CODE
, PSV.SYSTEM_LINKAGE_FUNCTION
, PSV.ORG_ID
, PSV.SAME_PA_GL_PERIOD
, PA_EXPENDITURES_UTILS.GETORGTLNAME(PSV.ORG_ID)
, PSV.SET_OF_BOOKS_ID
FROM PA_GL_CC_EXCEPT_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'))

Columns