APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 2878: FROM oe_order_headers_all ooh, oe_order_types_v oot

2874:
2875: BEGIN
2876: SELECT header_id
2877: INTO l_order_header_id
2878: FROM oe_order_headers_all ooh, oe_order_types_v oot
2879: WHERE ooh.order_type_id = oot.order_type_id
2880: AND ooh.header_id = l_org_src_header_id
2881: AND oot.order_category_code IN ('MIXED', 'ORDER');
2882: l_add_to_same_order := TRUE;

Line 2901: oe_order_headers_all ooh,

2897: SELECT MAX(ced.order_header_id)
2898: INTO l_order_header_id
2899: FROM CSD_PRODUCT_TRANSACTIONS cpt,
2900: cs_estimate_details ced,
2901: oe_order_headers_all ooh,
2902: oe_order_types_v oot
2903: WHERE ooh.order_type_id = oot.order_type_id
2904: AND ooh.header_id = ced.order_header_id
2905: AND oot.order_category_code IN ('MIXED', 'ORDER')

Line 3039: FROM oe_order_headers_all oe, cs_estimate_details ced

3035:
3036: BEGIN
3037: SELECT oe.order_number
3038: INTO l_order_number
3039: FROM oe_order_headers_all oe, cs_estimate_details ced
3040: WHERE oe.header_id = ced.order_header_id
3041: AND ced.estimate_detail_id = l_last_est_detail_id;
3042: Fnd_Message.SET_NAME('CSD', 'CSD_EST_ORDER_NUMBER');
3043: Fnd_Message.SET_TOKEN('ORDER_NUMBER', l_order_number);