1. Tables and Views for Sales and Fusion Service
  2. OKC_OPERATING_UNIT_V

OKC_OPERATING_UNIT_V

Details

  • Schema: FUSION

  • Object owner: OKC

  • Object type: VIEW

Columns

Name

PARTY_ID

PARTY_NUMBER

PARTY_NAME

STATUS

PARTY_TYPE

Query

SQL_Statement

SELECT BusinessUnitPEO.BU_ID AS PARTY_ID,

BusinessUnitPEO.BU_ID AS PARTY_NUMBER,

BusinessUnitPEO.BU_NAME AS PARTY_NAME,

BusinessUnitPEO.STATUS AS STATUS,

null AS PARTY_TYPE

FROM FUN_ALL_BUSINESS_UNITS_V BusinessUnitPEO