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_ITEM_BULKLOAD_PKG dependencies on EGO_ATTRS_V

Line 925: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE;

921: l_attr_group_id NUMBER;
922: l_attr_id NUMBER;
923: l_temp_str VARCHAR2(30); --R12C UOM Changes
924: l_attr_group_disp_name EGO_ATTR_GROUPS_V.ATTR_GROUP_DISP_NAME%TYPE;
925: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE;
926:
927: CURSOR c_attr_group_disp_name(p_attr_group_id IN NUMBER) IS
928: SELECT attr_group_disp_name
929: FROM ego_attr_groups_v

Line 934: FROM ego_attrs_v

930: WHERE attr_group_id = p_attr_group_id;
931:
932: CURSOR c_attr_disp_name(p_attr_id IN NUMBER) IS
933: SELECT attr_display_name
934: FROM ego_attrs_v
935: WHERE attr_id = p_attr_id;
936:
937: BEGIN
938:

Line 4425: FROM ego_attrs_v

4421: ,'X','D'
4422: ,'Y','D'
4423: ,data_type_code) data_type_code,
4424: uom_class -- R12C UOM Change
4425: FROM ego_attrs_v
4426: WHERE attr_id = p_attr_id
4427: AND attr_group_type in (G_IUD_ATTR_GROUP_TYPE, G_GTN_SNG_ATTR_GROUP_TYPE, G_GTN_MUL_ATTR_GROUP_TYPE)
4428: AND application_id = G_APPLICATION_ID;
4429:

Line 4503: l_attr_group_int_name EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE;

4499: l_transaction_type VARCHAR2(10);
4500: l_uom_class VARCHAR2(10); -- R12C UOM Change
4501: l_uom_meaning VARCHAR2(150); -- R12C UOM Change
4502:
4503: l_attr_group_int_name EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE;
4504: l_attr_int_name EGO_ATTRS_V.ATTR_NAME%TYPE;
4505: l_attr_data_type EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
4506: l_attr_group_type EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE;--Bug Fix 4630163(ISSUE2)
4507:

Line 4504: l_attr_int_name EGO_ATTRS_V.ATTR_NAME%TYPE;

4500: l_uom_class VARCHAR2(10); -- R12C UOM Change
4501: l_uom_meaning VARCHAR2(150); -- R12C UOM Change
4502:
4503: l_attr_group_int_name EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE;
4504: l_attr_int_name EGO_ATTRS_V.ATTR_NAME%TYPE;
4505: l_attr_data_type EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
4506: l_attr_group_type EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE;--Bug Fix 4630163(ISSUE2)
4507:
4508: ---------------------------------------------------------

Line 4505: l_attr_data_type EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;

4501: l_uom_meaning VARCHAR2(150); -- R12C UOM Change
4502:
4503: l_attr_group_int_name EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE;
4504: l_attr_int_name EGO_ATTRS_V.ATTR_NAME%TYPE;
4505: l_attr_data_type EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
4506: l_attr_group_type EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE;--Bug Fix 4630163(ISSUE2)
4507:
4508: ---------------------------------------------------------
4509: -- Example Data Types to be used in Bind Variable.

Line 4506: l_attr_group_type EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE;--Bug Fix 4630163(ISSUE2)

4502:
4503: l_attr_group_int_name EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE;
4504: l_attr_int_name EGO_ATTRS_V.ATTR_NAME%TYPE;
4505: l_attr_data_type EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
4506: l_attr_group_type EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE;--Bug Fix 4630163(ISSUE2)
4507:
4508: ---------------------------------------------------------
4509: -- Example Data Types to be used in Bind Variable.
4510: ---------------------------------------------------------

Line 5413: -- To get the Attribute Name (Table performs better than EGO_ATTRS_V) --

5409: || ' AND INSTR(attribute_code, ''$$UOM'') = 0 ' -- R12C UOM Change : ignoring uom columns in this case:
5410: || ' AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, ''$$'') - 1)) = :ATTR_GROUP_ID ';
5411:
5412: -------------------------------------------------------------------------
5413: -- To get the Attribute Name (Table performs better than EGO_ATTRS_V) --
5414: -------------------------------------------------------------------------
5415: CURSOR c_attr_name ( c_attr_id IN NUMBER) IS
5416: SELECT ext.application_column_name , TL.FORM_LEFT_PROMPT
5417: FROM ego_fnd_df_col_usgs_ext ext, FND_DESCR_FLEX_COL_USAGE_TL TL

Line 6725: FROM EGO_ATTRS_V

6721: CURSOR c_leafAttrs_bTable ( c_attr_group_type IN VARCHAR2 , c_edit_in_hcR IN VARCHAR2 , c_data_type_codeA IN VARCHAR2) IS
6722: SELECT DATABASE_COLUMN ,
6723: EDIT_IN_HIERARCHY_CODE ,
6724: DATA_TYPE_CODE
6725: FROM EGO_ATTRS_V
6726: WHERE ATTR_GROUP_TYPE = c_attr_group_type -- 'EGO_ITEM_GTIN_ATTRS'
6727: AND EDIT_IN_HIERARCHY_CODE IN ( c_edit_in_hcR ) -- ( 'L' , 'LP', 'A' , 'AP')
6728: AND DATA_TYPE_CODE not in ( c_data_type_codeA );
6729:

Line 6738: FROM EGO_ATTRS_V

6734: CURSOR c_rootAttrs_bTable ( c_attr_group_type IN VARCHAR2 , c_edit_in_hcL IN VARCHAR2 , c_edit_in_hcLP IN VARCHAR2 , c_data_type_codeA IN VARCHAR2 ) is
6735: SELECT DATABASE_COLUMN ,
6736: EDIT_IN_HIERARCHY_CODE ,
6737: DATA_TYPE_CODE
6738: FROM EGO_ATTRS_V
6739: WHERE ATTR_GROUP_TYPE = c_attr_group_type -- 'EGO_ITEM_GTIN_ATTRS'
6740: AND EDIT_IN_HIERARCHY_CODE IN ( c_edit_in_hcL , c_edit_in_hcLP ) -- ( 'L' , 'LP', 'A' , 'AP')
6741: AND DATA_TYPE_CODE not in ( c_data_type_codeA ) ;
6742:

Line 6751: FROM EGO_ATTRS_V

6747: CURSOR c_leafAttrs_tlTable ( c_attr_group_type IN VARCHAR2 , c_edit_in_hcR IN VARCHAR2 , c_data_type_codeA IN VARCHAR2) is
6748: SELECT DATABASE_COLUMN ,
6749: EDIT_IN_HIERARCHY_CODE ,
6750: DATA_TYPE_CODE
6751: FROM EGO_ATTRS_V
6752: WHERE ATTR_GROUP_TYPE = c_attr_group_type -- 'EGO_ITEM_GTIN_ATTRS'
6753: AND EDIT_IN_HIERARCHY_CODE IN ( c_edit_in_hcR ) -- ( 'L' , 'LP', 'A' , 'AP')
6754: AND DATA_TYPE_CODE in ( c_data_type_codeA ) ;
6755:

Line 6764: FROM EGO_ATTRS_V

6760: CURSOR c_rootAttrs_tlTable ( c_attr_group_type IN VARCHAR2 , c_edit_in_hcL IN VARCHAR2 , c_edit_in_hcLP IN VARCHAR2 , c_data_type_codeA IN VARCHAR2 ) is
6761: SELECT DATABASE_COLUMN ,
6762: EDIT_IN_HIERARCHY_CODE ,
6763: DATA_TYPE_CODE
6764: FROM EGO_ATTRS_V
6765: WHERE ATTR_GROUP_TYPE = c_attr_group_type -- 'EGO_ITEM_GTIN_ATTRS'
6766: AND EDIT_IN_HIERARCHY_CODE IN ( c_edit_in_hcL , c_edit_in_hcLP ) -- ( 'L' , 'LP', 'A' , 'AP')
6767: AND DATA_TYPE_CODE in ( c_data_type_codeA ) ;
6768: