1. Tables and Views for SCM
  2. MSC_SUB_INVENTORIES_V

MSC_SUB_INVENTORIES_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

PLAN_ID

ORGANIZATION_ID

SUB_INVENTORY_CODE

NETTING_TYPE

DESCRIPTION

INVENTORY_ATP_CODE

DISABLE_DATE

LOCATION_ID

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

REFRESH_NUMBER

INCLUDE_NON_NETTABLE

SUB_INVENTORY_ID

SUBINV_PLANNING_ENABLED

PAR_ENABLED

Query

SQL_Statement

SELECT

subinv.plan_id,

subinv.organization_id,

subinv.sub_inventory_code,

subinv.netting_type,

subinv.description,

subinv.inventory_atp_code,

subinv.disable_date,

subinv.location_id,

subinv.attribute_category,

subinv.attribute1,

subinv.attribute2,

subinv.attribute3,

subinv.attribute4,

subinv.attribute5,

subinv.attribute6,

subinv.attribute7,

subinv.attribute8,

subinv.attribute9,

subinv.attribute10,

subinv.attribute11,

subinv.attribute12,

subinv.attribute13,

subinv.attribute14,

subinv.attribute15,

subinv.refresh_number,

subinv.include_non_nettable,

orgsubinv.sub_inventory_id,

org.subinv_planning_enabled,

subinv.par_enabled

FROM

msc_sub_inventories subinv,

msc_org_sub_inventories orgsubinv,

msc_parameters org

WHERE subinv.organization_id = orgsubinv.organization_id (+)

AND subinv.sub_inventory_code = orgsubinv.sub_inventory_code (+)

AND org.organization_id = subinv.organization_id