[Home] [Help]
2325:
2326: BEGIN
2327: SELECT 'x'
2328: INTO l_check
2329: FROM cs_estimate_details
2330: WHERE estimate_detail_id = l_est_detail_id
2331: AND order_header_id IS NULL;
2332: l_upd_charge_flag := 'Y';
2333: EXCEPTION
2339:
2340: BEGIN
2341: SELECT business_process_id
2342: INTO l_bus_process_id
2343: FROM cs_estimate_details
2344: WHERE estimate_detail_id = l_est_detail_id;
2345: EXCEPTION
2346: WHEN NO_DATA_FOUND THEN
2347: Debug('No Business business_process_id', l_mod_name, C_STATEMENT_LEVEL);
2642: WHERE project_id = l_project_id and inventory_organization_id = l_p_ship_from_org_id;
2643:
2644: CURSOR order_line_cu(l_est_detail_id NUMBER) is
2645: SELECT b.order_line_id, a.ship_from_org_id
2646: FROM oe_order_lines_all a, cs_estimate_details b
2647: WHERE a.line_id = b.order_line_id
2648: AND b.estimate_detail_id = l_est_detail_id;
2649:
2650: -- swai: bug 6001057
2670:
2671: BEGIN
2672: SELECT 'X'
2673: INTO l_dummy
2674: FROM cs_estimate_details
2675: WHERE estimate_detail_id = p_prodtxn_db_attr.est_detail_id
2676: AND order_line_id IS NULL;
2677: EXCEPTION
2678: WHEN NO_DATA_FOUND THEN
2688: l_mod_name,
2689: 1);
2690: RAISE CREATE_ORDER;
2691: WHEN TOO_MANY_ROWS THEN
2692: Debug('Too many from cs_estimate_details',
2693: l_mod_name,
2694: 1);
2695: RAISE CREATE_ORDER;
2696: END;
2978: a.booked_flag
2979: INTO px_order_rec.order_header_id,
2980: l_order_line_id,
2981: l_booked_flag
2982: FROM oe_order_lines_all a, cs_estimate_details b
2983: WHERE a.line_id = b.order_line_id
2984: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id;
2985: EXCEPTION
2986: WHEN NO_DATA_FOUND THEN
3298: for serial reservations change for R12, Vijay June 9th 2006 */
3299: SELECT ship_from_org_id, header_id, line_id
3300: INTO l_ship_from_org_id, l_order_header_id, l_order_line_id
3301: FROM oe_order_lines_all oel,
3302: cs_estimate_details ced
3303: WHERE oel.line_id = ced.order_line_id
3304: AND ced.estimate_detail_id =
3305: p_product_txn_rec.estimate_detail_id;
3306: EXCEPTION
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:
3453: /*Bug#5049102
3454: Select order header id from estimate table directly
3455: */
3456: SELECT b.order_header_id
3457: INTO l_order_header_id
3458: FROM cs_estimate_details b
3459: WHERE b.estimate_detail_id = p_product_txn_rec.estimate_detail_id;
3460:
3461: /*Bug#5049102
3462: The query given below will find if there is any
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
3476: Added condition SOURCE_CODE = 'OE' while selecting
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:
3561: /*Bug#5049102
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');
3577:
3691: px_order_rec.order_line_id,
3692: px_order_rec.serial_number,
3693: px_order_rec.shipped_quantity
3694: FROM oe_order_lines_all a,
3695: cs_estimate_details b,
3696: CSD_PRODUCT_TRANSACTIONS c
3697: WHERE a.line_id = b.order_line_id
3698: AND b.estimate_detail_id = c.estimate_detail_id
3699: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id;