APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on OE_ORDER_TYPES_V

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 2891: oe_order_types_v oot

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')
2895: AND cpt.estimate_detail_id = ced.estimate_detail_id