DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_VALIDATIONS dependencies on OE_ORDER_LINES_ALL

Line 3135: oe_order_lines_all oel, po_requisition_lines_all pl

3131: -- Need to get receiving organization_id and destination type code for location
3132: CURSOR get_org_id (c_delivery_id NUMBER) IS
3133: SELECT pl.destination_organization_id, pl.destination_type_code
3134: FROM wsh_delivery_assignments wda, wsh_delivery_details wdd,
3135: oe_order_lines_all oel, po_requisition_lines_all pl
3136: WHERE wda.delivery_id = c_delivery_id
3137: AND wda.delivery_detail_id = wdd.delivery_detail_id
3138: AND wdd.source_document_type_id = 10
3139: AND wdd.source_line_id = oel.line_id