1. Tables and Views for SCM
  2. MSC_AP_ORGANIZATIONS_V

MSC_AP_ORGANIZATIONS_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

ORGANIZATION_CODE

ORGANIZATION_ID

MASTER_ORGANIZATION_ID

SOURCE_ORG_ID

CALENDAR_CODE

ORGANIZATION_NAME

BUSINESS_UNIT_NAME

LEGAL_ENTITY_NAME

CURRENCY_CODE

INVENTORY_FLAG

ROW_ID

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

PLANT_FLAG

PARTNER_NAME

PARTY_SITE_CODE

TIMEZONE_CODE

PROJECT_REFERENCE_ENABLED

ENABLE_IOT_FLAG

INCLUDE_OPER_YIELD

DEFAULT_INCL_PLAN_BULK

DEFAULT_INCL_PLAN_SUPPLIER

Query

SQL_Statement

SELECT

org.organization_code,

org.organization_id,

org.master_organization_id,

org.source_organization_id source_org_id,

nvl(mfgPlant.MFG_CALENDAR, org.schedule_id) calendar_code,

hrorgunit.name organization_name,

bu.BU_NAME BUSINESS_UNIT_NAME,

le.LEGAL_ENTITY_NAME,

le.currency_code,

org.INVENTORY_FLAG,

org.rowid row_id,

org.ATTRIBUTE1,

org.ATTRIBUTE2,

org.ATTRIBUTE3,

org.ATTRIBUTE4,

org.ATTRIBUTE5,

org.ATTRIBUTE6,

org.ATTRIBUTE7,

org.ATTRIBUTE8,

org.ATTRIBUTE9,

org.ATTRIBUTE10,

org.ATTRIBUTE11,

org.ATTRIBUTE12,

org.ATTRIBUTE13,

org.ATTRIBUTE14,

org.ATTRIBUTE15,

decode(org.MFG_PLANT_FLAG, 'Y' , 1 , 2) plant_flag,

supsite.partner_name,

supsite.vendor_site_code party_site_code,

org.timezone_code,

nvl(org.project_reference_enabled,2) project_reference_enabled,

decode(mfgPlant.enable_iot_flag, 'Y', 1, 2) enable_iot_flag,

decode(upper(mfgPlant.inc_oper_yield_flag),'Y',1,'N',2,to_number(NULL)) INCLUDE_OPER_YIELD,

decode(upper(mfgPlant.default_incl_plan_bulk) ,'Y',1,'N',2,to_number(NULL)) default_incl_plan_bulk,

decode(upper(mfgPlant.default_incl_plan_supplier),'Y',1,'N',2,to_number(NULL)) default_incl_plan_supplier

from /*( SELECT ORGANIZATION_ID,

TO_NUMBER(ORG_INFORMATION1) MODELED_CUSTOMER_ID,

TO_NUMBER(ORG_INFORMATION2) MODELED_CUSTOMER_SITE_ID,

TO_NUMBER(ORG_INFORMATION3) MODELED_SUPPLIER_ID,

TO_NUMBER(ORG_INFORMATION4) MODELED_SUPPLIER_SITE_ID

FROM HR_ORGANIZATION_INFORMATION

WHERE ORG_INFORMATION_CONTEXT='Customer/Supplier Association'

AND ( ORG_INFORMATION1 IS NOT NULL OR ORG_INFORMATION3 IS NOT NULL)) hrorginfo, */

HR_ALL_ORGANIZATION_UNITS_VL hrorgunit,

INV_ORG_PARAMETERS org,

GL_LEDGER_LE_V le,

FUN_BU_USAGES_V bu,

RCS_MFG_PARAMETERS mfgPlant,

MSC_AP_SUPPLIER_SITES_V supsite

where

hrorgunit.ORGANIZATION_ID(+) = org.ORGANIZATION_ID

and org.BUSINESS_UNIT_ID = bu.BUSINESS_UNIT_ID(+)

and org.LEGAL_ENTITY_ID = le.LEGAL_ENTITY_ID(+)

and bu.MODULE_KEY(+)='MATERIALS_MANAGEMENT_BF'

and le.LEDGER_CATEGORY_CODE(+)='PRIMARY'

and mfgPlant.organization_id(+) = org.organization_id

AND supsite.sr_tp_id(+) = org.supplier_id

AND supsite.sr_tp_site_id(+) = org.supplier_site_id