APPS.RLM_CUM_SV dependencies on WSH_DELIVERY_DETAILS

Line 1468: v_Primary_UOM_Code wsh_delivery_details.requested_quantity_uom%TYPE;

1464: x_msg_data VARCHAR2(4000);
1465: --
1466:
1467: --Used for UOM conversion: Bug 4439006
1468: v_Primary_UOM_Code wsh_delivery_details.requested_quantity_uom%TYPE;
1469: v_shipped_qty NUMBER;
1470:
1471: --Exception variables declaration
1472: e_general_error EXCEPTION;

Line 1485: WSH_DELIVERY_DETAILS wdel,

1481: CURSOR c_oe_header IS
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

Line 1521: WSH_DELIVERY_DETAILS wdel,

1517: oelines.source_document_line_id,
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

Line 3182: WSH_DELIVERY_DETAILS wdel,

3178: oelines.intmed_ship_to_org_id,
3179: oelines.invoice_to_org_id
3180: FROM WSH_DELIVERY_LEGS wleg,
3181: WSH_DELIVERY_ASSIGNMENTS_V wdass,
3182: WSH_DELIVERY_DETAILS wdel,
3183: OE_ORDER_LINES oelines
3184: WHERE wleg.pick_up_stop_id = x_trip_stop_id
3185: AND wdass.delivery_id = wleg.delivery_id
3186: AND wdel.delivery_detail_id = wdass.delivery_detail_id