VIEW: APPS.PSB_BUDGET_REVISION_POSITION_V

Source

View Text - Preformatted

SELECT BRPL.BUDGET_REVISION_ID,BRP.BUDGET_REVISION_POS_LINE_ID,BRP.POSITION_ID,PP.NAME,PP.HR_EMPLOYEE_ID,PE.EMPLOYEE_NUMBER,PE.FULL_NAME,BRP.BUDGET_GROUP_ID,BRP.EFFECTIVE_START_DATE,BRP.EFFECTIVE_END_DATE,BRP.REVISION_TYPE,BRP.REVISION_VALUE_TYPE,BRP.REVISION_VALUE,BRP.REVISION_VALUE,BRP.REVISION_VALUE,BRPL.FREEZE_FLAG,BRPL.VIEW_LINE_FLAG,BRP.LAST_UPDATE_DATE,BRP.LAST_UPDATED_BY,BRP.LAST_UPDATE_LOGIN,BRP.CREATION_DATE,BRP.CREATED_BY FROM PSB_BUDGET_REVISION_POSITIONS BRP,PSB_BUDGET_REVISION_POS_LINES BRPL,PSB_EMPLOYEES PE,PSB_POSITIONS PP,PSB_POSITION_ASSIGNMENTS PPE WHERE BRP.BUDGET_REVISION_POS_LINE_ID = BRPL.BUDGET_REVISION_POS_LINE_ID AND BRP.POSITION_ID = PP.POSITION_ID AND PP.POSITION_ID = PPE.POSITION_ID(+) AND PPE.ASSIGNMENT_TYPE (+) = 'EMPLOYEE' AND PPE.EMPLOYEE_ID = PE.EMPLOYEE_ID(+)

View Text - HTML Formatted

SELECT BRPL.BUDGET_REVISION_ID
, BRP.BUDGET_REVISION_POS_LINE_ID
, BRP.POSITION_ID
, PP.NAME
, PP.HR_EMPLOYEE_ID
, PE.EMPLOYEE_NUMBER
, PE.FULL_NAME
, BRP.BUDGET_GROUP_ID
, BRP.EFFECTIVE_START_DATE
, BRP.EFFECTIVE_END_DATE
, BRP.REVISION_TYPE
, BRP.REVISION_VALUE_TYPE
, BRP.REVISION_VALUE
, BRP.REVISION_VALUE
, BRP.REVISION_VALUE
, BRPL.FREEZE_FLAG
, BRPL.VIEW_LINE_FLAG
, BRP.LAST_UPDATE_DATE
, BRP.LAST_UPDATED_BY
, BRP.LAST_UPDATE_LOGIN
, BRP.CREATION_DATE
, BRP.CREATED_BY
FROM PSB_BUDGET_REVISION_POSITIONS BRP
, PSB_BUDGET_REVISION_POS_LINES BRPL
, PSB_EMPLOYEES PE
, PSB_POSITIONS PP
, PSB_POSITION_ASSIGNMENTS PPE
WHERE BRP.BUDGET_REVISION_POS_LINE_ID = BRPL.BUDGET_REVISION_POS_LINE_ID
AND BRP.POSITION_ID = PP.POSITION_ID
AND PP.POSITION_ID = PPE.POSITION_ID(+)
AND PPE.ASSIGNMENT_TYPE (+) = 'EMPLOYEE'
AND PPE.EMPLOYEE_ID = PE.EMPLOYEE_ID(+)