VIEW: APPS.PA_CINT_RUNS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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