DBA Data[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on EGO_ITEM_MATCHES

Line 12382: FROM EGO_ITEM_MATCHES

12378:
12379: IF p_new_status = G_CONF_MATCH THEN
12380: BEGIN
12381: SELECT 1 INTO l_item_in_matching_table
12382: FROM EGO_ITEM_MATCHES
12383: WHERE BATCH_ID = p_batch_id
12384: AND SOURCE_SYSTEM_ID = p_source_system_id
12385: AND SOURCE_SYSTEM_REFERENCE = p_source_system_reference
12386: AND INVENTORY_ITEM_ID = p_inventory_item_id

Line 12409: FROM EGO_ITEM_MATCHES

12405:
12406: IF l_need_resolve_unconf_status = FND_API.G_TRUE THEN
12407: SELECT decode(count(1), 0, G_UNCONF_NONE_MATCH, 1, G_UNCONF_SIGL_MATCH, G_UNCONF_MULT_match)
12408: INTO l_resolved_status
12409: FROM EGO_ITEM_MATCHES
12410: WHERE BATCH_ID = p_batch_id
12411: AND SOURCE_SYSTEM_ID = p_source_system_id
12412: AND SOURCE_SYSTEM_REFERENCE = p_source_system_reference;
12413: END IF;