DBA Data[Home] [Help]

APPS.RLM_CUM_SV dependencies on OE_ORDER_LINES_ALL

Line 1486: OE_ORDER_LINES_ALL oelines

1482: SELECT DISTINCT oelines.header_id, oelines.org_id
1483: FROM WSH_DELIVERY_LEGS wleg,
1484: WSH_DELIVERY_ASSIGNMENTS_V wdass,
1485: WSH_DELIVERY_DETAILS wdel,
1486: OE_ORDER_LINES_ALL oelines
1487: WHERE wleg.pick_up_stop_id = x_trip_stop_id
1488: AND wdass.delivery_id = wleg.delivery_id
1489: AND wdel.delivery_detail_id = wdass.delivery_detail_id
1490: AND oelines.shipped_quantity IS NOT NULL

Line 1522: OE_ORDER_LINES_ALL oelines

1518: oelines.org_id
1519: FROM WSH_DELIVERY_LEGS wleg,
1520: WSH_DELIVERY_ASSIGNMENTS_V wdass,
1521: WSH_DELIVERY_DETAILS wdel,
1522: OE_ORDER_LINES_ALL oelines
1523: WHERE wleg.pick_up_stop_id = x_trip_stop_id
1524: AND wdass.delivery_id = wleg.delivery_id
1525: AND wdel.delivery_detail_id = wdass.delivery_detail_id
1526: AND oelines.header_id+0 = v_oe_header_id --Bugfix 14827544

Line 5813: FROM oe_order_lines_all

5809: shipped_quantity,
5810: actual_shipment_date,
5811: order_quantity_uom,
5812: org_id
5813: FROM oe_order_lines_all
5814: WHERE (ship_from_org_id = x_ship_from_org_id
5815: OR x_ship_from_org_id IS NULL)
5816: AND (ship_to_org_id = x_ship_to_org_id
5817: OR x_ship_to_org_id IS NULL)