APPS.WMS_XDOCK_PEGGING_PUB dependencies on WIP_MATERIAL_SHORTAGES_V

Line 6564: FROM wip_material_shortages_v wmsv

6560: NULL AS secondary_uom_code,
6561: wmsv.project_id AS project_id,
6562: wmsv.task_id AS task_id,
6563: wmsv.wip_supply_type AS wip_supply_type
6564: FROM wip_material_shortages_v wmsv
6565: WHERE wmsv.organization_id = l_organization_id
6566: AND wmsv.inventory_item_id = l_inventory_item_id
6567: AND wmsv.wip_entity_type in (1, 2, 5)
6568: AND wmsv.date_required IS NOT NULL

Line 9872: -- date_required field in the view wip_material_shortages_v as the expected ship time. Other

9868: -- 8 - Internal Order
9869: -- Supply of type Receiving is material already received so there is no need to get an expected
9870: -- receipt time for that. SYSDATE at the time the crossdock peg is created will be used and stamped
9871: -- on the reservation. Demand of type WIP (backordered component demand) will always use the
9872: -- date_required field in the view wip_material_shortages_v as the expected ship time. Other
9873: -- source types will not currently be supported in this API.
9874: -- {{ }}
9875: -- {{******************** Procedure Get_Expected_Time ********************}}
9876: PROCEDURE Get_Expected_Time