CST_COST_ORGS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: CST
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
COST_ORG_ID COST_ORG_NAME COST_ORG_CODE EFFECTIVE_START_DATE EFFECTIVE_END_DATE STATUS LEGAL_ENTITY_ID |
問合せ
| 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' |