APPS.CSD_LOGISTICS_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 3274: l_released_status wsh_delivery_details.released_status%TYPE;

3270: ) IS
3271: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.pickrelease_prodtxn';
3272: l_ship_from_org_id NUMBER;
3273: l_picking_rule_id NUMBER;
3274: l_released_status wsh_delivery_details.released_status%TYPE;
3275: l_order_header_id NUMBER;
3276: l_return_status VARCHAR2(1);
3277: l_msg_count NUMBER;
3278: l_msg_data VARCHAR2(2000);

Line 3448: FROM wsh_delivery_details a,

3444: SELECT a.released_status,
3445: b.order_header_id
3446: INTO l_released_status,
3447: l_order_header_id
3448: FROM wsh_delivery_details a,
3449: cs_estimate_details b
3450: WHERE a.source_line_id = b.order_line_id
3451: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id; */
3452:

Line 3471: FROM wsh_delivery_details a,

3467: l_eligible_lines_pick_release:=0;
3468:
3469: SELECT count(*)
3470: INTO l_eligible_lines_pick_release
3471: FROM wsh_delivery_details a,
3472: cs_estimate_details b
3473: WHERE a.source_line_id = b.order_line_id
3474: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id
3475: /*Fixed for bug#5846054

Line 3477: delivery details from wsh_delivery_details. As per

3473: WHERE a.source_line_id = b.order_line_id
3474: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id
3475: /*Fixed for bug#5846054
3476: Added condition SOURCE_CODE = 'OE' while selecting
3477: delivery details from wsh_delivery_details. As per
3478: shipping team there can be multiple delivery lines
3479: with different source code can be created from
3480: inbound deliveries (WSH) and other is from order
3481: management (OE). While doing the pick release Depot

Line 3556: FROM wsh_delivery_details a,

3552: if more than one delivery exist for a given line id.
3553: */
3554: /* SELECT a.released_status
3555: INTO l_released_status
3556: FROM wsh_delivery_details a,
3557: cs_estimate_details b
3558: WHERE a.source_line_id = b.order_line_id
3559: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id;*/
3560:

Line 3572: FROM wsh_delivery_details a,

3568: l_eligible_lines_pick_release:=0;
3569:
3570: SELECT count(*)
3571: INTO l_eligible_lines_pick_release
3572: FROM wsh_delivery_details a,
3573: cs_estimate_details b
3574: WHERE a.source_line_id = b.order_line_id
3575: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id
3576: AND a.released_status in ('R','B','S');

Line 3674: l_released_status wsh_delivery_details.released_status%TYPE;

3670: ) IS
3671: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.ship_prodtxn';
3672: l_ship_from_org_id NUMBER;
3673: l_picking_rule_id NUMBER;
3674: l_released_status wsh_delivery_details.released_status%TYPE;
3675: l_return_status VARCHAR2(1);
3676: l_msg_count NUMBER;
3677: l_msg_data VARCHAR2(2000);
3678: ship_order EXCEPTION;

Line 3737: FROM wsh_delivery_details

3733:
3734: BEGIN
3735: SELECT released_status
3736: INTO l_released_status
3737: FROM wsh_delivery_details
3738: WHERE source_header_id =
3739: px_order_rec.order_header_id
3740: AND source_line_id = px_order_rec.order_line_id;
3741: EXCEPTION