APPS.RLM_CUM_SV dependencies on WSH_DELIVERY_DETAILS

Line 1459: v_Primary_UOM_Code wsh_delivery_details.requested_quantity_uom%TYPE;

1455: x_msg_data VARCHAR2(4000);
1456: --
1457:
1458: --Used for UOM conversion: Bug 4439006
1459: v_Primary_UOM_Code wsh_delivery_details.requested_quantity_uom%TYPE;
1460: v_shipped_qty NUMBER;
1461:
1462: --Exception variables declaration
1463: e_general_error EXCEPTION;

Line 1476: WSH_DELIVERY_DETAILS wdel,

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

Line 1512: WSH_DELIVERY_DETAILS wdel,

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

Line 3172: WSH_DELIVERY_DETAILS wdel,

3168: oelines.intmed_ship_to_org_id,
3169: oelines.invoice_to_org_id
3170: FROM WSH_DELIVERY_LEGS wleg,
3171: WSH_DELIVERY_ASSIGNMENTS_V wdass,
3172: WSH_DELIVERY_DETAILS wdel,
3173: OE_ORDER_LINES oelines
3174: WHERE wleg.pick_up_stop_id = x_trip_stop_id
3175: AND wdass.delivery_id = wleg.delivery_id
3176: AND wdel.delivery_detail_id = wdass.delivery_detail_id