APPS.OE_ELECMSGS_PVT dependencies on OE_PROCESSING_MSGS

Line 125: and exists (select 1 from oe_processing_msgs msg

121: where x.order_source_id = p_order_source_id
122: and (x.orig_sys_document_ref = p_orig_sys_document_ref or p_orig_sys_document_ref IS NULL)
123: and x.sold_to_org_id = p_sold_to_org_id
124: and (x.em_transaction_type_code = p_transaction_type or p_transaction_type IS NULL)
125: and exists (select 1 from oe_processing_msgs msg
126: where msg.order_source_id = x.order_source_id
127: and msg.original_sys_document_ref = x.orig_sys_document_ref
128: and ((msg.entity_code like 'ELECMSG%' and msg.entity_id = to_number(x.item_key)) or x.em_conc_request_id = msg.request_id)
129: and msg.message_status_code = p_message_status_code)

Line 152: and exists (select 1 from oe_processing_msgs msg

148: where x.order_source_id = p_order_source_id
149: and (x.orig_sys_document_ref = p_orig_sys_document_ref or p_orig_sys_document_ref IS NULL)
150: and (x.sold_to_org_id = p_sold_to_org_id or p_sold_to_org_id IS NULL)
151: and (x.em_transaction_type_code = p_transaction_type or p_transaction_type IS NULL)
152: and exists (select 1 from oe_processing_msgs msg
153: where msg.order_source_id = x.order_source_id
154: and msg.original_sys_document_ref = x.orig_sys_document_ref
155: and ((msg.entity_code like 'ELECMSG%' and msg.entity_id = to_number(x.item_key)) or x.em_conc_request_id = msg.request_id)
156: and msg.message_status_code = p_message_status_code)

Line 178: and exists (select 1 from oe_processing_msgs msg

174: where x.order_source_id between l_min_order_source_id and l_max_order_source_id
175: and (x.orig_sys_document_ref = p_orig_sys_document_ref or p_orig_sys_document_ref IS NULL)
176: and x.sold_to_org_id = p_sold_to_org_id
177: and (x.em_transaction_type_code = p_transaction_type or p_transaction_type IS NULL)
178: and exists (select 1 from oe_processing_msgs msg
179: where msg.order_source_id = x.order_source_id
180: and msg.original_sys_document_ref = x.orig_sys_document_ref
181: and ((msg.entity_code like 'ELECMSG%' and msg.entity_id = to_number(x.item_key)) or x.em_conc_request_id = msg.request_id)
182: and msg.message_status_code = p_message_status_code)

Line 204: and exists (select 1 from oe_processing_msgs msg

200: where x.order_source_id between l_min_order_source_id and l_max_order_source_id
201: and (x.orig_sys_document_ref = p_orig_sys_document_ref or p_orig_sys_document_ref IS NULL)
202: and (x.sold_to_org_id = p_sold_to_org_id or p_sold_to_org_id IS NULL)
203: and (x.em_transaction_type_code = p_transaction_type or p_transaction_type IS NULL)
204: and exists (select 1 from oe_processing_msgs msg
205: where msg.order_source_id = x.order_source_id
206: and msg.original_sys_document_ref = x.orig_sys_document_ref
207: and ((msg.entity_code like 'ELECMSG%' and msg.entity_id = to_number(x.item_key)) or x.em_conc_request_id = msg.request_id)
208: and msg.message_status_code = p_message_status_code)