eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.EGO_ODI_PUB dependencies on EGO_ODI_WS_ENTITIES

Line 1329: --(SELECT pk1_value, pk2_value, pk3_value FROM EGO_ODI_WS_ENTITIES ent1

1325: -- So, the following query retreives the end-items for the component
1326: FOR i IN (SELECT item_id, item_org_id, item_rev FROM BOM_ODI_WS_ENTITIES
1327: where group_id = l_group_id and session_id = p_session_id)
1328:
1329: --(SELECT pk1_value, pk2_value, pk3_value FROM EGO_ODI_WS_ENTITIES ent1
1330: -- WHERE session_id = p_session_id and
1331: -- SEQUENCE_NUMBER IN (
1332: -- SELECT PK4_VALUE
1333: -- FROM EGO_ODI_WS_ENTITIES ent2

Line 1333: -- FROM EGO_ODI_WS_ENTITIES ent2

1329: --(SELECT pk1_value, pk2_value, pk3_value FROM EGO_ODI_WS_ENTITIES ent1
1330: -- WHERE session_id = p_session_id and
1331: -- SEQUENCE_NUMBER IN (
1332: -- SELECT PK4_VALUE
1333: -- FROM EGO_ODI_WS_ENTITIES ent2
1334: -- WHERE PK1_VALUE = l_item_id
1335: -- AND PK2_VALUE = l_org_id
1336: -- AND ent1.session_id = ent2.session_id
1337: -- ))

Line 4380: ' from EGO_ODI_WS_ENTITIES i ' ||

4376:
4377: IF l_sec_predicate IS NOT NULL THEN
4378:
4379: l_dynamic_sql := ' select pk1_value, pk2_value, pk3_value ' ||
4380: ' from EGO_ODI_WS_ENTITIES i ' ||
4381: ' where i.session_id = :1 ' ||
4382: ' AND nvl(i.REF1_VALUE, ''Y'') = ''Y'' ' ||
4383: ' AND NOT ' || l_sec_predicate;
4384:

Line 6428: INSERT INTO ego_odi_ws_entities ( session_id,odi_session_id,entity_type,pk1_value,pk2_value,pk3_value,pk4_value,pk5_value,ref1_value)

6424: l_icc_ver_tab(l_unique_icc_count):= j.version_seq_id;
6425: l_unique_icc_count:=l_unique_icc_count+1;
6426:
6427:
6428: INSERT INTO ego_odi_ws_entities ( session_id,odi_session_id,entity_type,pk1_value,pk2_value,pk3_value,pk4_value,pk5_value,ref1_value)
6429: VALUES (p_session_id,p_odi_session_id,'ItemCatalogCategory',j.item_catalog_group_id,j.version_seq_id,NULL,NULL,NULL,l_ref1_value);
6430:
6431:
6432: IF( j.item_catalog_group_id <> l_dup_icc_id_tab(i)) THEN --Bug Fix 8708269.Dont insert record for main Entity again

Line 6520: INSERT INTO ego_odi_ws_entities ( session_id,odi_session_id,entity_type,pk1_value,pk2_value,pk3_value,pk4_value,pk5_value,ref1_value)

6516: l_icc_id_tab(l_unique_icc_count):= j.item_catalog_group_id;
6517: l_icc_ver_tab(l_unique_icc_count):= j.version_seq_id;
6518: l_unique_icc_count:=l_unique_icc_count+1;
6519:
6520: INSERT INTO ego_odi_ws_entities ( session_id,odi_session_id,entity_type,pk1_value,pk2_value,pk3_value,pk4_value,pk5_value,ref1_value)
6521: VALUES (p_session_id,p_odi_session_id,'ItemCatalogCategory',j.item_catalog_group_id,j.version_seq_id,NULL,NULL,NULL,l_ref1_value);
6522:
6523: END IF; -- END IF(NOT l_is_duplicate) THEN
6524:

Line 6708: INSERT INTO ego_odi_ws_entities ( session_id,odi_session_id,entity_type,pk1_value,pk2_value,pk3_value,pk4_value,pk5_value,ref1_value)

6704: l_vs_ver_tab(l_unique_val_count):=j.version_seq_id; -- NULL; l_dup_vs_ver_tab(i);
6705: l_unique_val_count:=l_unique_val_count+1;
6706:
6707:
6708: INSERT INTO ego_odi_ws_entities ( session_id,odi_session_id,entity_type,pk1_value,pk2_value,pk3_value,pk4_value,pk5_value,ref1_value)
6709: VALUES (p_session_id,p_odi_session_id,'ValueSet',j.value_set_id,j.version_seq_id,NULL,NULL,NULL,l_ref1_value);
6710:
6711:
6712: IF( j.value_set_id <> l_dup_vs_ver_tab(i)) THEN --Bug Fix 8708269.Dont insert record for main Entity again

Line 6754: INSERT INTO ego_odi_ws_entities ( session_id,odi_session_id,entity_type,pk1_value,pk2_value,pk3_value,pk4_value,pk5_value,ref1_value)

6750: l_vs_ver_tab(l_unique_val_count):= l_dup_vs_ver_tab(i);
6751: l_unique_val_count:=l_unique_val_count+1;
6752:
6753:
6754: INSERT INTO ego_odi_ws_entities ( session_id,odi_session_id,entity_type,pk1_value,pk2_value,pk3_value,pk4_value,pk5_value,ref1_value)
6755: VALUES (p_session_id,p_odi_session_id,'ValueSet',l_dup_vs_id_tab(i),l_dup_vs_ver_tab(i),NULL,NULL,NULL,l_ref1_value);
6756:
6757: END IF;
6758:

Line 6817: INSERT INTO ego_odi_ws_entities ( session_id,odi_session_id,entity_type,pk1_value,pk2_value,pk3_value,pk4_value,pk5_value,ref1_value)

6813: l_vs_id_tab(l_unique_val_count):= j.value_set_id;
6814: l_vs_ver_tab(l_unique_val_count):= j.version_seq_id;
6815: l_unique_val_count:=l_unique_val_count+1;
6816:
6817: INSERT INTO ego_odi_ws_entities ( session_id,odi_session_id,entity_type,pk1_value,pk2_value,pk3_value,pk4_value,pk5_value,ref1_value)
6818: VALUES (p_session_id,p_odi_session_id,'ValueSet',j.value_set_id,j.version_seq_id,NULL,NULL,NULL,l_ref1_value);
6819:
6820: END IF;
6821: l_is_duplicate:=FALSE;

Line 6860: INSERT INTO ego_odi_ws_entities ( session_id,odi_session_id,entity_type,pk1_value,pk2_value,pk3_value,pk4_value,pk5_value,ref1_value)

6856: l_vs_id_tab(l_unique_val_count):= l_dup_vs_id_tab(i);
6857: l_vs_ver_tab(l_unique_val_count):= l_dup_vs_ver_tab(i);
6858: l_unique_val_count:=l_unique_val_count+1;
6859:
6860: INSERT INTO ego_odi_ws_entities ( session_id,odi_session_id,entity_type,pk1_value,pk2_value,pk3_value,pk4_value,pk5_value,ref1_value)
6861: VALUES (p_session_id,p_odi_session_id,'ValueSet',l_dup_vs_id_tab(i),l_dup_vs_ver_tab(i),NULL,NULL,NULL,l_ref1_value);
6862:
6863: END IF;
6864: l_is_duplicate:=FALSE;