eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_CINT_RUNS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_CINT_RUNS_V

View Text

SELECT PARN.RUN_ID
, PARN.RUN_PERIOD
, PARN.EXPND_ITEM_DATE
, PARN.DENOM_CURRENCY_CODE
, PARN.CREATION_DATE
, PARN.CREATED_BY
, FNDU.USER_NAME
, PARN.LAST_UPDATE_DATE
, PARN.LAST_UPDATED_BY
, PARN.LAST_UPDATE_LOGIN
, PARN.PERIOD_TYPE
, PARN.AUTO_RELEASE_FLAG
, PARN.CINT_RATE_NAME
, PARN.TARGET_EXP_TYPE_CLASS
, PSL1.MEANING
, PARN.TARGET_EXP_TYPE
, PARN.RUN_STATUS
, PL1.MEANING
, PARN.TARGET_EXP_GROUP
, PARN.ALLOCATED_AMOUNT
, PARN.DRAFT_REQUEST_ID
, PARN.DRAFT_REQUEST_DATE
, PARN.RELEASE_REQUEST_ID
, PARN.RELEASE_REQUEST_DATE
, PARN.REVERSAL_DATE
, PARN.REV_TARGET_EXP_GROUP
, PARN.FISCAL_YEAR
, PARN.QUARTER
, PARN.PERIOD_NUM
, PARN.ORG_ID
FROM FND_USER FNDU
, PA_LOOKUPS PL1
, PA_ALLOC_RUNS PARN
, PA_SYSTEM_LINKAGES PSL1
WHERE PARN.RUN_STATUS = PL1.LOOKUP_CODE
AND PL1.LOOKUP_TYPE = 'ALLOC_RUN_STATUS'
AND FNDU.USER_ID = PARN.CREATED_BY
AND PARN.TARGET_EXP_TYPE_CLASS = PSL1.FUNCTION (+)
AND PARN.RULE_ID=-1

Columns

Name
RUN_ID
RUN_PERIOD
EXPND_ITEM_DATE
DENOM_CURRENCY_CODE
CREATION_DATE
CREATED_BY
CREATED_BY_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
PERIOD_TYPE
AUTO_RELEASE_FLAG
CINT_RATE_NAME
TARGET_EXP_TYPE_CLASS
TARGET_EXP_TYPE_CLASS_DISP
TARGET_EXP_TYPE
RUN_STATUS_CODE
RUN_STATUS
TARGET_EXP_GROUP
ALLOCATED_AMOUNT
DRAFT_REQUEST_ID
DRAFT_REQUEST_DATE
RELEASE_REQUEST_ID
RELEASE_REQUEST_DATE
REVERSAL_DATE
REV_TARGET_EXP_GROUP
FISCAL_YEAR
QUARTER
PERIOD_NUM
ORG_ID