APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 2867: FROM oe_order_headers_all ooh, oe_order_types_v oot

2863:
2864: BEGIN
2865: SELECT header_id
2866: INTO l_order_header_id
2867: FROM oe_order_headers_all ooh, oe_order_types_v oot
2868: WHERE ooh.order_type_id = oot.order_type_id
2869: AND ooh.header_id = l_org_src_header_id
2870: AND oot.order_category_code IN ('MIXED', 'ORDER');
2871: l_add_to_same_order := TRUE;

Line 2890: oe_order_headers_all ooh,

2886: SELECT MAX(ced.order_header_id)
2887: INTO l_order_header_id
2888: FROM CSD_PRODUCT_TRANSACTIONS cpt,
2889: cs_estimate_details ced,
2890: oe_order_headers_all ooh,
2891: oe_order_types_v oot
2892: WHERE ooh.order_type_id = oot.order_type_id
2893: AND ooh.header_id = ced.order_header_id
2894: AND oot.order_category_code IN ('MIXED', 'ORDER')

Line 3028: FROM oe_order_headers_all oe, cs_estimate_details ced

3024:
3025: BEGIN
3026: SELECT oe.order_number
3027: INTO l_order_number
3028: FROM oe_order_headers_all oe, cs_estimate_details ced
3029: WHERE oe.header_id = ced.order_header_id
3030: AND ced.estimate_detail_id = l_last_est_detail_id;
3031: Fnd_Message.SET_NAME('CSD', 'CSD_EST_ORDER_NUMBER');
3032: Fnd_Message.SET_TOKEN('ORDER_NUMBER', l_order_number);