[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;
2985: a.booked_flag
2986: INTO px_order_rec.order_header_id,
2987: l_order_line_id,
2988: l_booked_flag
2989: FROM oe_order_lines_all a, cs_estimate_details b
2990: WHERE a.line_id = b.order_line_id
2991: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id;
2992: EXCEPTION
2993: WHEN NO_DATA_FOUND THEN
3312: for serial reservations change for R12, Vijay June 9th 2006 */
3313: SELECT ship_from_org_id, header_id, line_id
3314: INTO l_ship_from_org_id, l_order_header_id, l_order_line_id
3315: FROM oe_order_lines_all oel,
3316: cs_estimate_details ced
3317: WHERE oel.line_id = ced.order_line_id
3318: AND ced.estimate_detail_id =
3319: p_product_txn_rec.estimate_detail_id;
3320: EXCEPTION
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:
3467: /*Bug#5049102
3468: Select order header id from estimate table directly
3469: */
3470: SELECT b.order_header_id
3471: INTO l_order_header_id
3472: FROM cs_estimate_details b
3473: WHERE b.estimate_detail_id = p_product_txn_rec.estimate_detail_id;
3474:
3475: /*Bug#5049102
3476: The query given below will find if there is any
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
3490: Added condition SOURCE_CODE = 'OE' while selecting
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:
3575: /*Bug#5049102
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');
3591:
3705: px_order_rec.order_line_id,
3706: px_order_rec.serial_number,
3707: px_order_rec.shipped_quantity
3708: FROM oe_order_lines_all a,
3709: cs_estimate_details b,
3710: CSD_PRODUCT_TRANSACTIONS c
3711: WHERE a.line_id = b.order_line_id
3712: AND b.estimate_detail_id = c.estimate_detail_id
3713: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id;