1. Tables and Views for SCM
  2. CST_COST_ORGS_V

CST_COST_ORGS_V

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: VIEW

Columns

Name

COST_ORG_ID

COST_ORG_NAME

COST_ORG_CODE

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

STATUS

LEGAL_ENTITY_ID

Query

SQL_Statement

SELECT haou.organization_id COST_ORG_ID,

haou.name COST_ORG_NAME,

hoif.ORG_INFORMATION2 COST_ORG_CODE,

haou.effective_start_date EFFECTIVE_START_DATE,

haou.effective_end_date EFFECTIVE_END_DATE,

houc.status status,

hoif.org_information_number1 legal_entity_id

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'

AND houc.status='A'