APPS.CSD_LOGISTICS_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 3288: l_released_status wsh_delivery_details.released_status%TYPE;

3284: ) IS
3285: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.pickrelease_prodtxn';
3286: l_ship_from_org_id NUMBER;
3287: l_picking_rule_id NUMBER;
3288: l_released_status wsh_delivery_details.released_status%TYPE;
3289: l_order_header_id NUMBER;
3290: l_return_status VARCHAR2(1);
3291: l_msg_count NUMBER;
3292: l_msg_data VARCHAR2(2000);

Line 3462: FROM wsh_delivery_details a,

3458: SELECT a.released_status,
3459: b.order_header_id
3460: INTO l_released_status,
3461: l_order_header_id
3462: FROM wsh_delivery_details a,
3463: cs_estimate_details b
3464: WHERE a.source_line_id = b.order_line_id
3465: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id; */
3466:

Line 3485: FROM wsh_delivery_details a,

3481: l_eligible_lines_pick_release:=0;
3482:
3483: SELECT count(*)
3484: INTO l_eligible_lines_pick_release
3485: FROM wsh_delivery_details a,
3486: cs_estimate_details b
3487: WHERE a.source_line_id = b.order_line_id
3488: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id
3489: /*Fixed for bug#5846054

Line 3491: delivery details from wsh_delivery_details. As per

3487: WHERE a.source_line_id = b.order_line_id
3488: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id
3489: /*Fixed for bug#5846054
3490: Added condition SOURCE_CODE = 'OE' while selecting
3491: delivery details from wsh_delivery_details. As per
3492: shipping team there can be multiple delivery lines
3493: with different source code can be created from
3494: inbound deliveries (WSH) and other is from order
3495: management (OE). While doing the pick release Depot

Line 3570: FROM wsh_delivery_details a,

3566: if more than one delivery exist for a given line id.
3567: */
3568: /* SELECT a.released_status
3569: INTO l_released_status
3570: FROM wsh_delivery_details a,
3571: cs_estimate_details b
3572: WHERE a.source_line_id = b.order_line_id
3573: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id;*/
3574:

Line 3586: FROM wsh_delivery_details a,

3582: l_eligible_lines_pick_release:=0;
3583:
3584: SELECT count(*)
3585: INTO l_eligible_lines_pick_release
3586: FROM wsh_delivery_details a,
3587: cs_estimate_details b
3588: WHERE a.source_line_id = b.order_line_id
3589: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id
3590: AND a.released_status in ('R','B','S');

Line 3688: l_released_status wsh_delivery_details.released_status%TYPE;

3684: ) IS
3685: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.ship_prodtxn';
3686: l_ship_from_org_id NUMBER;
3687: l_picking_rule_id NUMBER;
3688: l_released_status wsh_delivery_details.released_status%TYPE;
3689: l_return_status VARCHAR2(1);
3690: l_msg_count NUMBER;
3691: l_msg_data VARCHAR2(2000);
3692: ship_order EXCEPTION;

Line 3751: FROM wsh_delivery_details

3747:
3748: BEGIN
3749: SELECT released_status
3750: INTO l_released_status
3751: FROM wsh_delivery_details
3752: WHERE source_header_id =
3753: px_order_rec.order_header_id
3754: AND source_line_id = px_order_rec.order_line_id;
3755: EXCEPTION