PJF_BU_IMPL_ALL

Details

Schema: FUSION
Object owner: PJF
Object type: VIEW

Columns

Name
ORG_ID BU_NAME LOCATION_ID BUSINESS_GROUP_ID DATE_FROM DATE_TO SHORT_CODE MANAGER_ID PRIMARY_LEDGER_ID DEFAULT_SET_ID LEGAL_ENTITY_ID PA_PERIOD_TYPE EXP_CYCLE_START_DAY_CODE OVERTIME_CALC_ENABLED_FLAG EXP_TREE_STRUCTURE_CODE EXP_TREE_VERSION_ID EXP_TREE_CODE EXP_START_ORG_ID PROJ_TREE_STRUCTURE_CODE PROJ_TREE_VERSION_ID PROJ_TREE_CODE 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

Name

ORG_ID

BU_NAME

LOCATION_ID

BUSINESS_GROUP_ID

DATE_FROM

DATE_TO

SHORT_CODE

MANAGER_ID

PRIMARY_LEDGER_ID

DEFAULT_SET_ID

LEGAL_ENTITY_ID

PA_PERIOD_TYPE

EXP_CYCLE_START_DAY_CODE

OVERTIME_CALC_ENABLED_FLAG

EXP_TREE_STRUCTURE_CODE

EXP_TREE_VERSION_ID

EXP_TREE_CODE

EXP_START_ORG_ID

PROJ_TREE_STRUCTURE_CODE

PROJ_TREE_VERSION_ID

PROJ_TREE_CODE

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 PjfBU.ORG_ID, ORG.NAME BU_NAME, ORG.LOCATION_ID, ORG.BUSINESS_GROUP_ID, ORG.EFFECTIVE_START_DATE DATE_FROM, ORG.EFFECTIVE_END_DATE DATE_TO, ORG.NAME SHORT_CODE, INFO.ORG_INFORMATION1 MANAGER_ID, INFO.ORG_INFORMATION3 PRIMARY_LEDGER_ID, INFO.ORG_INFORMATION4 DEFAULT_SET_ID, INFO.ORG_INFORMATION2 LEGAL_ENTITY_ID, PjfBU.PA_PERIOD_TYPE, PjfBU.EXP_CYCLE_START_DAY_CODE, PjfBU.OVERTIME_CALC_ENABLED_FLAG, PjfBU.EXP_TREE_STRUCTURE_CODE, PjfBU.EXP_TREE_VERSION_ID, PjfBU.EXP_TREE_CODE, PjfBU.EXP_START_ORG_ID, PjfBU.PROJ_TREE_STRUCTURE_CODE, PjfBU.PROJ_TREE_VERSION_ID, PjfBU.PROJ_TREE_CODE, PjfBU.PROJ_START_ORG_ID, PjfBU.RET_PROCESS_FLAG, PjfBU.CC_PROCESS_IO_CODE, PjfBU.CC_DEFAULT_RATE_TYPE, PjfBU.CC_DEFAULT_RATE_DATE_CODE, PjfBU.CC_ALLOW_IU_FLAG, PjfBU.CC_PROCESS_IU_CODE, PjfBU.PERIOD_SET_NAME, PjfBU.SAME_PA_GL_PERIOD, PjfBU.BOOK_TYPE_CODE, PjfBU.OBJECT_VERSION_NUMBER, PjfBU.DEF_SUPPLIER_COST_CR_CCID, PjfBU.DEFAULT_RATE_DATE_CODE, PjfBU.DEFAULT_RATE_TYPE, pjfBU.SEPARATION_OF_DUTIES_FLAG FROM PJF_BU_IMPL_ALL PjfBU, HR_ALL_ORGANIZATION_UNITS_F_VL ORG, HR_ORGANIZATION_INFORMATION_X INFO WHERE PjfBU.ORG_ID = ORG.ORGANIZATION_ID AND TRUNC(SYSDATE) BETWEEN ORG.EFFECTIVE_START_DATE AND ORG.EFFECTIVE_END_DATE AND INFO.ORGANIZATION_ID = ORG.ORGANIZATION_ID AND INFO.ORG_INFORMATION_CONTEXT = 'FUN_BUSINESS_UNIT'

SQL_Statement

SELECT PjfBU.ORG_ID,

ORG.NAME BU_NAME,

ORG.LOCATION_ID,

ORG.BUSINESS_GROUP_ID,

ORG.EFFECTIVE_START_DATE DATE_FROM,

ORG.EFFECTIVE_END_DATE DATE_TO,

ORG.NAME SHORT_CODE,

INFO.ORG_INFORMATION1 MANAGER_ID,

INFO.ORG_INFORMATION3 PRIMARY_LEDGER_ID,

INFO.ORG_INFORMATION4 DEFAULT_SET_ID,

INFO.ORG_INFORMATION2 LEGAL_ENTITY_ID,

PjfBU.PA_PERIOD_TYPE,

PjfBU.EXP_CYCLE_START_DAY_CODE,

PjfBU.OVERTIME_CALC_ENABLED_FLAG,

PjfBU.EXP_TREE_STRUCTURE_CODE,

PjfBU.EXP_TREE_VERSION_ID,

PjfBU.EXP_TREE_CODE,

PjfBU.EXP_START_ORG_ID,

PjfBU.PROJ_TREE_STRUCTURE_CODE,

PjfBU.PROJ_TREE_VERSION_ID,

PjfBU.PROJ_TREE_CODE,

PjfBU.PROJ_START_ORG_ID,

PjfBU.RET_PROCESS_FLAG,

PjfBU.CC_PROCESS_IO_CODE,

PjfBU.CC_DEFAULT_RATE_TYPE,

PjfBU.CC_DEFAULT_RATE_DATE_CODE,

PjfBU.CC_ALLOW_IU_FLAG,

PjfBU.CC_PROCESS_IU_CODE,

PjfBU.PERIOD_SET_NAME,

PjfBU.SAME_PA_GL_PERIOD,

PjfBU.BOOK_TYPE_CODE,

PjfBU.OBJECT_VERSION_NUMBER,

PjfBU.DEF_SUPPLIER_COST_CR_CCID,

PjfBU.DEFAULT_RATE_DATE_CODE,

PjfBU.DEFAULT_RATE_TYPE,

pjfBU.SEPARATION_OF_DUTIES_FLAG

FROM PJF_BU_IMPL_ALL PjfBU,

HR_ALL_ORGANIZATION_UNITS_F_VL ORG,

HR_ORGANIZATION_INFORMATION_X INFO

WHERE PjfBU.ORG_ID = ORG.ORGANIZATION_ID

AND TRUNC(SYSDATE) BETWEEN ORG.EFFECTIVE_START_DATE AND ORG.EFFECTIVE_END_DATE

AND INFO.ORGANIZATION_ID = ORG.ORGANIZATION_ID

AND INFO.ORG_INFORMATION_CONTEXT = 'FUN_BUSINESS_UNIT'