WIE_INV_MAT_RESERVATIONS_V

Details

  • Schema: FUSION

  • Object owner: WIE

  • Object type: VIEW

Columns

Name

DEMAND_SOURCE_HEADER_ID

ORGANIZATION_ID

MATERIAL_RESERVED

Query

SQL_Statement

SELECT DISTINCT DEMAND_SOURCE_HEADER_ID, ORGANIZATION_ID, 'Y' AS MATERIAL_RESERVED FROM INV_RESERVATIONS WHERE DEMAND_SOURCE_TYPE_ID=5