APPS.WMS_XDOCK_PEGGING_PUB dependencies on WIP_MATERIAL_SHORTAGES_V

Line 6389: FROM wip_material_shortages_v wmsv

6385: NULL AS secondary_uom_code,
6386: wmsv.project_id AS project_id,
6387: wmsv.task_id AS task_id,
6388: wmsv.wip_supply_type AS wip_supply_type
6389: FROM wip_material_shortages_v wmsv
6390: WHERE wmsv.organization_id = l_organization_id
6391: AND wmsv.inventory_item_id = l_inventory_item_id
6392: AND wmsv.wip_entity_type in (1, 2, 5)
6393: AND wmsv.date_required IS NOT NULL

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

9673: -- 8 - Internal Order
9674: -- Supply of type Receiving is material already received so there is no need to get an expected
9675: -- receipt time for that. SYSDATE at the time the crossdock peg is created will be used and stamped
9676: -- on the reservation. Demand of type WIP (backordered component demand) will always use the
9677: -- date_required field in the view wip_material_shortages_v as the expected ship time. Other
9678: -- source types will not currently be supported in this API.
9679: -- {{ }}
9680: -- {{******************** Procedure Get_Expected_Time ********************}}
9681: PROCEDURE Get_Expected_Time