PJF_BU_IMPL_V

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name

ORG_ID BU_NAME LOCATION_ID BUSINESS_GROUP_ID DATE_FROM DATE_TO MANAGER_ID LEGAL_ENTITY_ID PRIMARY_LEDGER_ID DEFAULT_SET_ID SHORT_CODE PA_PERIOD_TYPE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN EXP_CYCLE_START_DAY_CODE OVERTIME_CALC_ENABLED_FLAG EXP_TREE_STRUCTURE_CODE EXP_TREE_VERSION_ID EXP_TREE_CODE PROJ_TREE_CODE EXP_START_ORG_ID PROJ_TREE_STRUCTURE_CODE PROJ_TREE_VERSION_ID PROJ_START_ORG_ID RET_PROCESS_FLAG CC_PROCESS_IO_CODE CC_DEFAULT_RATE_TYPE CC_DEFAULT_RATE_DATE_CODE CC_ALLOW_IU_FLAG CC_PROCESS_IU_CODE PERIOD_SET_NAME SAME_PA_GL_PERIOD BOOK_TYPE_CODE OBJECT_VERSION_NUMBER DEF_SUPPLIER_COST_CR_CCID DEFAULT_RATE_DATE_CODE DEFAULT_RATE_TYPE SEPARATION_OF_DUTIES_FLAG

Query

SQL_Statement

SELECT PJF_BU_IMPL_ALL.ORG_ID ORG_ID, ORG.NAME BU_NAME, ORG.LOCATION_ID LOCATION_ID, ORG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORG.EFFECTIVE_START_DATE DATE_FROM, ORG.EFFECTIVE_END_DATE DATE_TO, INFO.ORG_INFORMATION1 MANAGER_ID, INFO.ORG_INFORMATION2 LEGAL_ENTITY_ID, INFO.ORG_INFORMATION3 PRIMARY_LEDGER_ID, INFO.ORG_INFORMATION4 DEFAULT_SET_ID, ORG.NAME SHORT_CODE, PJF_BU_IMPL_ALL.PA_PERIOD_TYPE PA_PERIOD_TYPE, PJF_BU_IMPL_ALL.LAST_UPDATE_DATE LAST_UPDATE_DATE, PJF_BU_IMPL_ALL.LAST_UPDATED_BY LAST_UPDATED_BY, PJF_BU_IMPL_ALL.CREATION_DATE CREATION_DATE, PJF_BU_IMPL_ALL.CREATED_BY CREATED_BY, PJF_BU_IMPL_ALL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PJF_BU_IMPL_ALL.EXP_CYCLE_START_DAY_CODE EXP_CYCLE_START_DAY_CODE, PJF_BU_IMPL_ALL.OVERTIME_CALC_ENABLED_FLAG OVERTIME_CALC_ENABLED_FLAG, PJF_BU_IMPL_ALL.EXP_TREE_STRUCTURE_CODE EXP_TREE_STRUCTURE_CODE, PJF_BU_IMPL_ALL.EXP_TREE_VERSION_ID EXP_TREE_VERSION_ID, PJF_BU_IMPL_ALL.EXP_TREE_CODE EXP_TREE_CODE, PJF_BU_IMPL_ALL.PROJ_TREE_CODE PROJ_TREE_CODE, PJF_BU_IMPL_ALL.EXP_START_ORG_ID EXP_START_ORG_ID, PJF_BU_IMPL_ALL.PROJ_TREE_STRUCTURE_CODE PROJ_TREE_STRUCTURE_CODE, PJF_BU_IMPL_ALL.PROJ_TREE_VERSION_ID PROJ_TREE_VERSION_ID, PJF_BU_IMPL_ALL.PROJ_START_ORG_ID PROJ_START_ORG_ID, PJF_BU_IMPL_ALL.RET_PROCESS_FLAG, PJF_BU_IMPL_ALL.CC_PROCESS_IO_CODE CC_PROCESS_IO_CODE, PJF_BU_IMPL_ALL.CC_DEFAULT_RATE_TYPE CC_DEFAULT_RATE_TYPE, PJF_BU_IMPL_ALL.CC_DEFAULT_RATE_DATE_CODE CC_DEFAULT_RATE_DATE_CODE, PJF_BU_IMPL_ALL.CC_ALLOW_IU_FLAG CC_ALLOW_IU_FLAG, PJF_BU_IMPL_ALL.CC_PROCESS_IU_CODE CC_PROCESS_IU_CODE, PJF_BU_IMPL_ALL.PERIOD_SET_NAME PERIOD_SET_NAME, PJF_BU_IMPL_ALL.SAME_PA_GL_PERIOD SAME_PA_GL_PERIOD, PJF_BU_IMPL_ALL.BOOK_TYPE_CODE BOOK_TYPE_CODE, PJF_BU_IMPL_ALL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PJF_BU_IMPL_ALL.DEF_SUPPLIER_COST_CR_CCID DEF_SUPPLIER_COST_CR_CCID, PJF_BU_IMPL_ALL.DEFAULT_RATE_DATE_CODE DEFAULT_RATE_DATE_CODE, PJF_BU_IMPL_ALL.DEFAULT_RATE_TYPE DEFAULT_RATE_TYPE, PJF_BU_IMPL_ALL.SEPARATION_OF_DUTIES_FLAG FROM PJF_BU_IMPL_ALL, HR_ALL_ORGANIZATION_UNITS_F_VL ORG , HR_ORGANIZATION_INFORMATION_X INFO WHERE PJF_BU_IMPL_ALL.ORG_ID = ORG.ORGANIZATION_ID AND INFO.ORGANIZATION_ID = ORG.ORGANIZATION_ID AND INFO.ORG_INFORMATION_CONTEXT = 'FUN_BUSINESS_UNIT' AND TRUNC(SYSDATE) BETWEEN ORG.EFFECTIVE_START_DATE AND ORG.EFFECTIVE_END_DATE