1. Tables and Views for SCM
  2. CST_CST_DETERMINANT_VALUE_VL

CST_CST_DETERMINANT_VALUE_VL

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: VIEW

Columns

Name

DETERMINANT_VALUE_ID

DETERMINANT_VALUE_DISPLAY_NAME

DETERMINANT_VALUE_CODE

Query

SQL_Statement

SELECT haou.organization_id DETERMINANT_VALUE_ID,

haou.name DETERMINANT_VALUE_DISPLAY_NAME,

hoif.ORG_INFORMATION2 DETERMINANT_VALUE_CODE

FROM hr_all_organization_units_f_vl haou,

hr_org_unit_classifications_f houc,

hr_organization_information_f hoif

WHERE haou.organization_id = houc.organization_id

AND TRUNC(sysdate) BETWEEN haou.effective_start_date AND haou.effective_end_date

AND TRUNC(sysdate) BETWEEN houc.effective_start_date AND houc.effective_end_date

AND TRUNC(sysdate) BETWEEN hoif.effective_start_date AND hoif.effective_end_date

AND hoif.organization_id = haou.organization_id

AND houc.classification_code = 'CST'

AND hoif.org_information_context = 'CST_ACCOUNTING_INFO'