1. Tables and Views for SCM
  2. MSC_AP_SUB_INVENTORIES_V

MSC_AP_SUB_INVENTORIES_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

ORGANIZATION_ID

ORGANIZATION_CODE

SUB_INVENTORY_CODE

DESCRIPTION

DISABLE_DATE

NETTING_TYPE

INVENTORY_ATP_CODE

ROW_ID

LOCATION_CODE

PAR_ENABLED

Query

SQL_Statement

SELECT

x.ORGANIZATION_ID,

mp.ORGANIZATION_CODE,

x.SECONDARY_INVENTORY_NAME SUB_INVENTORY_CODE,

x.DESCRIPTION,

x.DISABLE_DATE,

x.AVAILABILITY_TYPE NETTING_TYPE,

x.INVENTORY_ATP_CODE,

x.rowid row_id,

TO_CHAR(x.LOCATION_ID) LOCATION_CODE,

nvl(x.planning_level,2) par_enabled

FROM INV_SECONDARY_INVENTORIES x,

INV_ORG_PARAMETERS_V mp

WHERE mp.ORGANIZATION_ID = x.ORGANIZATION_ID

AND trunc(NVL(x.DISABLE_DATE,sysdate)) >= trunc(SYSDATE)