VIEW: APPS.BEN_OPT_D

Source

View Text - Preformatted

SELECT OPT.ROWID ROW_ID , OPT.OPT_ID , OPT.EFFECTIVE_START_DATE , OPT.EFFECTIVE_END_DATE , OPT.NAME , CMBN_PTIP_OPT.NAME , OPT.LAST_UPDATE_DATE , FUSER.LAST_UPDATED_BY , opt.SHORT_NAME , opt.SHORT_CODE , opt.COMPONENT_REASON , opt.mapping_table_name , opt.mapping_table_pk_id , opt.LEGISLATION_CODE , opt.LEGISLATION_SUBGROUP FROM BEN_OPT_F OPT, FND_USER FUSER ,BEN_CMBN_PTIP_OPT_F CMBN_PTIP_OPT WHERE FUSER.USER_ID (+)= OPT.LAST_UPDATED_BY AND CMBN_PTIP_OPT.CMBN_PTIP_OPT_ID (+)= OPT.CMBN_PTIP_OPT_ID

View Text - HTML Formatted

SELECT OPT.ROWID ROW_ID
, OPT.OPT_ID
, OPT.EFFECTIVE_START_DATE
, OPT.EFFECTIVE_END_DATE
, OPT.NAME
, CMBN_PTIP_OPT.NAME
, OPT.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
, OPT.SHORT_NAME
, OPT.SHORT_CODE
, OPT.COMPONENT_REASON
, OPT.MAPPING_TABLE_NAME
, OPT.MAPPING_TABLE_PK_ID
, OPT.LEGISLATION_CODE
, OPT.LEGISLATION_SUBGROUP
FROM BEN_OPT_F OPT
, FND_USER FUSER
, BEN_CMBN_PTIP_OPT_F CMBN_PTIP_OPT
WHERE FUSER.USER_ID (+)= OPT.LAST_UPDATED_BY
AND CMBN_PTIP_OPT.CMBN_PTIP_OPT_ID (+)= OPT.CMBN_PTIP_OPT_ID