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.

APPS.EGO_IMPORT_PVT dependencies on EGO_ATTRS_V

Line 809: --6468564:Perf issue replacing EGO_ATTRS_V

805: , p_master_org_id IN NUMBER DEFAULT NULL
806: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
807: )
808: IS
809: --6468564:Perf issue replacing EGO_ATTRS_V
810: CURSOR c_pdh_target_rev_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE, cp_rev_dl_id NUMBER ) IS
811: SELECT sub.*
812: ,EXT.DATA_TYPE DATA_TYPE_CODE
813: FROM

Line 892: --6468564:Perf issue replacing EGO_ATTRS_V

888: AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = FL_COL.DESCRIPTIVE_FLEX_CONTEXT_CODE
889: AND EXT.APPLICATION_COLUMN_NAME = FL_COL.APPLICATION_COLUMN_NAME
890: ORDER BY rnk, sub.last_update_date DESC, interface_table_unique_id DESC ;
891:
892: --6468564:Perf issue replacing EGO_ATTRS_V
893: CURSOR c_ss_target_rev_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE, cp_rev_dl_id NUMBER ) IS
894: SELECT sub.*
895: ,EXT.DATA_TYPE DATA_TYPE_CODE
896: FROM

Line 991: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;

987: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
988: l_mrow_ix PLS_INTEGER := 0;
989: l_is_pdh_batch BOOLEAN;
990:
991: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
992:
993: l_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE := p_master_org_id;
994: l_pdh_batch_flag FLAG := p_is_pdh_batch;
995: l_rev_dl_id NUMBER;

Line 1239: --6468564:Perf issue replacing EGO_ATTRS_V

1235: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
1236: )
1237: IS
1238:
1239: --6468564:Perf issue replacing EGO_ATTRS_V
1240: CURSOR c_pdh_target_item_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE ) IS
1241: SELECT sub.*
1242: ,EXT.DATA_TYPE DATA_TYPE_CODE
1243: FROM

Line 1319: --6468564 : Perf issue replacing EGO_ATTRS_V

1315: AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = FL_COL.DESCRIPTIVE_FLEX_CONTEXT_CODE
1316: AND EXT.APPLICATION_COLUMN_NAME = FL_COL.APPLICATION_COLUMN_NAME
1317: ORDER BY rnk, sub.last_update_date DESC, interface_table_unique_id DESC ;
1318:
1319: --6468564 : Perf issue replacing EGO_ATTRS_V
1320: CURSOR c_ss_target_item_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE ) IS
1321: SELECT sub.*
1322: ,EXT.DATA_TYPE DATA_TYPE_CODE
1323: FROM

Line 1416: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;

1412: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
1413: l_mrow_ix PLS_INTEGER := 0;
1414: l_is_pdh_batch BOOLEAN;
1415:
1416: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
1417: l_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE := p_master_org_id;
1418: l_pdh_batch_flag FLAG := p_is_pdh_batch;
1419:
1420: l_proc_log_prefix CONSTANT VARCHAR2(30) := ' merge_item_attrs - ';

Line 4388: , EGO_ATTRS_V attrs

4384: AND A.DATA_LEVEL_ID = DL.DATA_LEVEL_ID
4385: AND A.ATTR_GROUP_ID = FL_CTX_EXT.ATTR_GROUP_ID
4386: )
4387: ) sub
4388: , EGO_ATTRS_V attrs
4389: WHERE sub.CNT > 1
4390: AND attrs.APPLICATION_ID = 431
4391: AND attrs.ATTR_GROUP_NAME = sub.ATTR_GROUP_INT_NAME
4392: AND attrs.ATTR_NAME = sub.ATTR_INT_NAME

Line 4410: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;

4406: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
4407: l_mrow_ix PLS_INTEGER := 0;
4408: l_new_row_idx PLS_INTEGER := 0;
4409:
4410: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
4411:
4412: l_proc_log_prefix CONSTANT VARCHAR2(50) := 'Merge_Item_Attrs_For_Import - ';
4413: BEGIN
4414: Debug_Conc_Log( l_proc_log_prefix || 'Entering' );

Line 4700: , EGO_ATTRS_V attrs

4696: WHERE A.DATA_LEVEL_ID = cp_rev_dl_id
4697: AND A.ATTR_GROUP_ID = FL_CTX_EXT.ATTR_GROUP_ID
4698: )
4699: ) sub
4700: , EGO_ATTRS_V attrs
4701: WHERE sub.CNT > 1
4702: AND attrs.APPLICATION_ID = 431
4703: AND attrs.ATTR_GROUP_NAME = sub.ATTR_GROUP_INT_NAME
4704: AND attrs.ATTR_NAME = sub.ATTR_INT_NAME

Line 4723: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;

4719: l_mrow_ix PLS_INTEGER := 0;
4720: l_new_row_idx PLS_INTEGER := 0;
4721: l_rev_dl_id NUMBER;
4722:
4723: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
4724:
4725: l_proc_log_prefix CONSTANT VARCHAR2(50) := 'Merge_Rev_Attrs_For_Import - ';
4726: BEGIN
4727: Debug_Conc_Log( l_proc_log_prefix || 'Entering' );