APPS.OE_HOLD_SOURCES_PVT dependencies on OE_ORDER_HEADERS

Line 116: FROM OE_ORDER_HEADERS

112: ELSIF p_entity_code = 'O' THEN
113:
114: SELECT 'x'
115: INTO l_dummy
116: FROM OE_ORDER_HEADERS
117: WHERE header_id = p_entity_id;
118:
119: END IF; -- Validate Entity ID
120:

Line 185: FROM OE_ORDER_HEADERS

181: ELSIF p_entity_code2 = 'O' THEN
182:
183: SELECT 'x'
184: INTO l_dummy
185: FROM OE_ORDER_HEADERS
186: WHERE header_id = p_entity_id2;
187:
188: END IF; -- Validate Entity ID
189:

Line 899: -- FROM wf_item_activity_statuses_v wf, oe_order_headers h,

895: IS
896: l_site_code VARCHAR2(30);
897: --CURSOR customer_wf IS
898: -- SELECT wf.item_type item_type, wf.item_key item_key
899: -- FROM wf_item_activity_statuses_v wf, oe_order_headers h,
900: -- oe_order_lines_all l
901: -- WHERE activity_name = 'CHECK_HOLDS'
902: -- AND activity_status_code = 'NOTIFIED'
903: -- AND ( (item_type = 'OEOH'

Line 939: -- FROM wf_item_activity_statuses_v wf, oe_order_headers h,

935: -- AND item_key = to_char(l.line_id)
936: -- AND l.inventory_item_id = p_entity_id;
937: --CURSOR order_wf IS
938: -- SELECT wf.item_type item_type, wf.item_key item_key
939: -- FROM wf_item_activity_statuses_v wf, oe_order_headers h,
940: -- oe_order_lines_all l
941: -- WHERE activity_name = 'CHECK_HOLDS'
942: -- AND activity_status_code = 'NOTIFIED'
943: -- AND ( (item_type = 'OEOH'