DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_VALIDATIONS dependencies on PO_REQUISITION_LINES_ALL

Line 3139: oe_order_lines_all oel, po_requisition_lines_all pl

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