DBA Data[Home] [Help]

APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on OE_ORDER_TYPES_V

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

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