VIEW: APPS.WIP_OPEN_DEMANDS_V

Source

View Text - Preformatted

SELECT owodv.organization_id, owodv.demand_source_header_id, owodv.demand_order_header_id, owodv.demand_source_line_id, owodv.demand_source_line_number, owodv.requirement_date, owodv.inventory_item_id, owodv.demand_class_code, owodv.demand_uom_code, owodv.demand_open_quantity, /* 10 */ msi.primary_uom_code, inv_convert.inv_um_convert(owodv.inventory_item_id, 6, owodv.demand_open_quantity, owodv.demand_uom_code, msi.primary_uom_code, NULL, NULL), msi.replenish_to_order_flag /* 13 */ from oe_wip_open_demands_v owodv, mtl_system_items msi where msi.build_in_wip_flag = 'Y' and msi.pick_components_flag = 'N' and msi.bom_item_type = 4 /* standard */ and msi.organization_id = owodv.organization_id and msi.inventory_item_id = owodv.inventory_item_id

View Text - HTML Formatted

SELECT OWODV.ORGANIZATION_ID
, OWODV.DEMAND_SOURCE_HEADER_ID
, OWODV.DEMAND_ORDER_HEADER_ID
, OWODV.DEMAND_SOURCE_LINE_ID
, OWODV.DEMAND_SOURCE_LINE_NUMBER
, OWODV.REQUIREMENT_DATE
, OWODV.INVENTORY_ITEM_ID
, OWODV.DEMAND_CLASS_CODE
, OWODV.DEMAND_UOM_CODE
, OWODV.DEMAND_OPEN_QUANTITY
, /* 10 */ MSI.PRIMARY_UOM_CODE
, INV_CONVERT.INV_UM_CONVERT(OWODV.INVENTORY_ITEM_ID
, 6
, OWODV.DEMAND_OPEN_QUANTITY
, OWODV.DEMAND_UOM_CODE
, MSI.PRIMARY_UOM_CODE
, NULL
, NULL)
, MSI.REPLENISH_TO_ORDER_FLAG /* 13 */
FROM OE_WIP_OPEN_DEMANDS_V OWODV
, MTL_SYSTEM_ITEMS MSI
WHERE MSI.BUILD_IN_WIP_FLAG = 'Y'
AND MSI.PICK_COMPONENTS_FLAG = 'N'
AND MSI.BOM_ITEM_TYPE = 4 /* STANDARD */
AND MSI.ORGANIZATION_ID = OWODV.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = OWODV.INVENTORY_ITEM_ID