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 888: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE;

884: l_attr_group_id NUMBER;
885: l_attr_id NUMBER;
886: l_temp_str VARCHAR2(30); --R12C UOM Changes
887: l_attr_group_disp_name EGO_ATTR_GROUPS_V.ATTR_GROUP_DISP_NAME%TYPE;
888: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE;
889:
890: CURSOR c_attr_group_disp_name(p_attr_group_id IN NUMBER) IS
891: SELECT attr_group_disp_name
892: FROM ego_attr_groups_v

Line 897: FROM ego_attrs_v

893: WHERE attr_group_id = p_attr_group_id;
894:
895: CURSOR c_attr_disp_name(p_attr_id IN NUMBER) IS
896: SELECT attr_display_name
897: FROM ego_attrs_v
898: WHERE attr_id = p_attr_id;
899:
900: BEGIN
901:

Line 4340: FROM ego_attrs_v

4336: ,'X','D'
4337: ,'Y','D'
4338: ,data_type_code) data_type_code,
4339: uom_class -- R12C UOM Change
4340: FROM ego_attrs_v
4341: WHERE attr_id = p_attr_id
4342: AND attr_group_type in (G_IUD_ATTR_GROUP_TYPE, G_GTN_SNG_ATTR_GROUP_TYPE, G_GTN_MUL_ATTR_GROUP_TYPE)
4343: AND application_id = G_APPLICATION_ID;
4344:

Line 4418: l_attr_group_int_name EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE;

4414: l_transaction_type VARCHAR2(10);
4415: l_uom_class VARCHAR2(10); -- R12C UOM Change
4416: l_uom_meaning VARCHAR2(150); -- R12C UOM Change
4417:
4418: l_attr_group_int_name EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE;
4419: l_attr_int_name EGO_ATTRS_V.ATTR_NAME%TYPE;
4420: l_attr_data_type EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
4421: l_attr_group_type EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE;--Bug Fix 4630163(ISSUE2)
4422:

Line 4419: l_attr_int_name EGO_ATTRS_V.ATTR_NAME%TYPE;

4415: l_uom_class VARCHAR2(10); -- R12C UOM Change
4416: l_uom_meaning VARCHAR2(150); -- R12C UOM Change
4417:
4418: l_attr_group_int_name EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE;
4419: l_attr_int_name EGO_ATTRS_V.ATTR_NAME%TYPE;
4420: l_attr_data_type EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
4421: l_attr_group_type EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE;--Bug Fix 4630163(ISSUE2)
4422:
4423: ---------------------------------------------------------

Line 4420: l_attr_data_type EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;

4416: l_uom_meaning VARCHAR2(150); -- R12C UOM Change
4417:
4418: l_attr_group_int_name EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE;
4419: l_attr_int_name EGO_ATTRS_V.ATTR_NAME%TYPE;
4420: l_attr_data_type EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
4421: l_attr_group_type EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE;--Bug Fix 4630163(ISSUE2)
4422:
4423: ---------------------------------------------------------
4424: -- Example Data Types to be used in Bind Variable.

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

4417:
4418: l_attr_group_int_name EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE;
4419: l_attr_int_name EGO_ATTRS_V.ATTR_NAME%TYPE;
4420: l_attr_data_type EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
4421: l_attr_group_type EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE;--Bug Fix 4630163(ISSUE2)
4422:
4423: ---------------------------------------------------------
4424: -- Example Data Types to be used in Bind Variable.
4425: ---------------------------------------------------------

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

5319: || ' AND INSTR(attribute_code, ''$$UOM'') = 0 ' -- R12C UOM Change : ignoring uom columns in this case:
5320: || ' AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, ''$$'') - 1)) = :ATTR_GROUP_ID ';
5321:
5322: -------------------------------------------------------------------------
5323: -- To get the Attribute Name (Table performs better than EGO_ATTRS_V) --
5324: -------------------------------------------------------------------------
5325: CURSOR c_attr_name ( c_attr_id IN NUMBER) IS
5326: SELECT ext.application_column_name , TL.FORM_LEFT_PROMPT
5327: FROM ego_fnd_df_col_usgs_ext ext, FND_DESCR_FLEX_COL_USAGE_TL TL

Line 6572: FROM EGO_ATTRS_V

6568: CURSOR c_leafAttrs_bTable ( c_attr_group_type IN VARCHAR2 , c_edit_in_hcR IN VARCHAR2 , c_data_type_codeA IN VARCHAR2) IS
6569: SELECT DATABASE_COLUMN ,
6570: EDIT_IN_HIERARCHY_CODE ,
6571: DATA_TYPE_CODE
6572: FROM EGO_ATTRS_V
6573: WHERE ATTR_GROUP_TYPE = c_attr_group_type -- 'EGO_ITEM_GTIN_ATTRS'
6574: AND EDIT_IN_HIERARCHY_CODE IN ( c_edit_in_hcR ) -- ( 'L' , 'LP', 'A' , 'AP')
6575: AND DATA_TYPE_CODE not in ( c_data_type_codeA );
6576:

Line 6585: FROM EGO_ATTRS_V

6581: 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
6582: SELECT DATABASE_COLUMN ,
6583: EDIT_IN_HIERARCHY_CODE ,
6584: DATA_TYPE_CODE
6585: FROM EGO_ATTRS_V
6586: WHERE ATTR_GROUP_TYPE = c_attr_group_type -- 'EGO_ITEM_GTIN_ATTRS'
6587: AND EDIT_IN_HIERARCHY_CODE IN ( c_edit_in_hcL , c_edit_in_hcLP ) -- ( 'L' , 'LP', 'A' , 'AP')
6588: AND DATA_TYPE_CODE not in ( c_data_type_codeA ) ;
6589:

Line 6598: FROM EGO_ATTRS_V

6594: CURSOR c_leafAttrs_tlTable ( c_attr_group_type IN VARCHAR2 , c_edit_in_hcR IN VARCHAR2 , c_data_type_codeA IN VARCHAR2) is
6595: SELECT DATABASE_COLUMN ,
6596: EDIT_IN_HIERARCHY_CODE ,
6597: DATA_TYPE_CODE
6598: FROM EGO_ATTRS_V
6599: WHERE ATTR_GROUP_TYPE = c_attr_group_type -- 'EGO_ITEM_GTIN_ATTRS'
6600: AND EDIT_IN_HIERARCHY_CODE IN ( c_edit_in_hcR ) -- ( 'L' , 'LP', 'A' , 'AP')
6601: AND DATA_TYPE_CODE in ( c_data_type_codeA ) ;
6602:

Line 6611: FROM EGO_ATTRS_V

6607: 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
6608: SELECT DATABASE_COLUMN ,
6609: EDIT_IN_HIERARCHY_CODE ,
6610: DATA_TYPE_CODE
6611: FROM EGO_ATTRS_V
6612: WHERE ATTR_GROUP_TYPE = c_attr_group_type -- 'EGO_ITEM_GTIN_ATTRS'
6613: AND EDIT_IN_HIERARCHY_CODE IN ( c_edit_in_hcL , c_edit_in_hcLP ) -- ( 'L' , 'LP', 'A' , 'AP')
6614: AND DATA_TYPE_CODE in ( c_data_type_codeA ) ;
6615: