DBA Data[Home] [Help]

APPS.RLM_CUM_SV dependencies on OE_ORDER_LINES_ALL

Line 1477: OE_ORDER_LINES_ALL oelines

1473: SELECT DISTINCT oelines.header_id, oelines.org_id
1474: FROM WSH_DELIVERY_LEGS wleg,
1475: WSH_DELIVERY_ASSIGNMENTS_V wdass,
1476: WSH_DELIVERY_DETAILS wdel,
1477: OE_ORDER_LINES_ALL oelines
1478: WHERE wleg.pick_up_stop_id = x_trip_stop_id
1479: AND wdass.delivery_id = wleg.delivery_id
1480: AND wdel.delivery_detail_id = wdass.delivery_detail_id
1481: AND oelines.shipped_quantity IS NOT NULL

Line 1513: OE_ORDER_LINES_ALL oelines

1509: oelines.org_id
1510: FROM WSH_DELIVERY_LEGS wleg,
1511: WSH_DELIVERY_ASSIGNMENTS_V wdass,
1512: WSH_DELIVERY_DETAILS wdel,
1513: OE_ORDER_LINES_ALL oelines
1514: WHERE wleg.pick_up_stop_id = x_trip_stop_id
1515: AND wdass.delivery_id = wleg.delivery_id
1516: AND wdel.delivery_detail_id = wdass.delivery_detail_id
1517: AND oelines.header_id = v_oe_header_id

Line 5803: FROM oe_order_lines_all

5799: shipped_quantity,
5800: actual_shipment_date,
5801: order_quantity_uom,
5802: org_id
5803: FROM oe_order_lines_all
5804: WHERE (ship_from_org_id = x_ship_from_org_id
5805: OR x_ship_from_org_id IS NULL)
5806: AND (ship_to_org_id = x_ship_to_org_id
5807: OR x_ship_to_org_id IS NULL)