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

Line 68: l_attr_sequence EGO_ATTRS_V.SEQUENCE%TYPE;

64:
65:
66: l_association_id NUMBER;
67: l_attr_id NUMBER:=0;
68: l_attr_sequence EGO_ATTRS_V.SEQUENCE%TYPE;
69: l_value_set_id NUMBER;
70: l_uom_class VARCHAR2(10);
71: l_default_value VARCHAR2(2000);
72: l_rejectedvalue VARCHAR2(2000);

Line 86: l_attr_name EGO_ATTRS_V.ATTR_NAME%TYPE:=NULL;

82: l_programid NUMBER;
83: l_programupdatedate DATE;
84: l_requestid NUMBER;
85: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE;
86: l_attr_name EGO_ATTRS_V.ATTR_NAME%TYPE:=NULL;
87: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE:=NULL;
88: l_data_type VARCHAR2(1);
89: l_display VARCHAR2(1);
90:

Line 87: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE:=NULL;

83: l_programupdatedate DATE;
84: l_requestid NUMBER;
85: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE;
86: l_attr_name EGO_ATTRS_V.ATTR_NAME%TYPE:=NULL;
87: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE:=NULL;
88: l_data_type VARCHAR2(1);
89: l_display VARCHAR2(1);
90:
91: l_api_name CONSTANT VARCHAR2(30) := 'Create_Transaction_Attribute';

Line 568: ego_attrs_v attrs ,

564: attrs.attr_name ,
565: attrs.attr_id ,
566: hier.lev
567: FROM ego_obj_AG_assocs_b assocs ,
568: ego_attrs_v attrs ,
569: ego_attr_groups_v ag ,
570: EGO_TRANS_ATTR_VERS_B versions ,
571: mtl_item_catalog_groups_kfv icv ,
572: (SELECT item_catalog_group_id ,

Line 637: EGO_ATTRS_V ATTRS ,

633: versions.metadata_level ,
634: attrs.attr_name ,
635: Hier.lev
636: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
637: EGO_ATTRS_V ATTRS ,
638: (SELECT ITEM_CATALOG_GROUP_ID ,
639: LEVEL LEV
640: FROM MTL_ITEM_CATALOG_GROUPS_B START
641: WITH ITEM_CATALOG_GROUP_ID = p_item_cat_group_id CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID

Line 1301: l_attr_sequence EGO_ATTRS_V.SEQUENCE%TYPE;

1297: l_msg_count NUMBER;
1298: l_msg_data VARCHAR2(2000);
1299: l_association_id NUMBER;
1300: l_attr_id NUMBER:=0;
1301: l_attr_sequence EGO_ATTRS_V.SEQUENCE%TYPE;
1302: l_value_set_id NUMBER;
1303: l_uom_class VARCHAR2(10);
1304: l_default_value VARCHAR2(2000);
1305: l_rejectedvalue VARCHAR2(2000);

Line 1319: l_attr_name EGO_ATTRS_V.ATTR_NAME%TYPE :=NULL;

1315: l_programid NUMBER;
1316: l_programupdatedate DATE;
1317: l_requestid NUMBER;
1318: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE;
1319: l_attr_name EGO_ATTRS_V.ATTR_NAME%TYPE :=NULL;
1320: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE:=NULL;
1321: l_data_type VARCHAR2(1);
1322: l_display VARCHAR2(1);
1323: l_api_name CONSTANT VARCHAR2(30) := 'Create_Inherited_Trans_Attr';

Line 1320: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE:=NULL;

1316: l_programupdatedate DATE;
1317: l_requestid NUMBER;
1318: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE;
1319: l_attr_name EGO_ATTRS_V.ATTR_NAME%TYPE :=NULL;
1320: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE:=NULL;
1321: l_data_type VARCHAR2(1);
1322: l_display VARCHAR2(1);
1323: l_api_name CONSTANT VARCHAR2(30) := 'Create_Inherited_Trans_Attr';
1324: l_data_level_id NUMBER;

Line 1569: l_attr_sequence EGO_ATTRS_V.SEQUENCE%TYPE;

1565: l_msg_data VARCHAR2(2000);
1566:
1567: l_association_id NUMBER;
1568: l_attr_id NUMBER;
1569: l_attr_sequence EGO_ATTRS_V.SEQUENCE%TYPE;
1570: l_value_set_id NUMBER;
1571: l_uom_class VARCHAR2(10);
1572: l_default_value VARCHAR2(2000);
1573: l_rejectedvalue VARCHAR2(2000);

Line 1580: l_attr_name EGO_ATTRS_V.ATTR_NAME%TYPE:=NULL;

1576: l_hiddenflag VARCHAR2(1);
1577: l_searchable VARCHAR2(1);
1578: l_checkeligibility VARCHAR2(1);
1579: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE;
1580: l_attr_name EGO_ATTRS_V.ATTR_NAME%TYPE:=NULL;
1581: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE:=NULL;
1582: l_data_type VARCHAR2(1);
1583: l_display VARCHAR2(1);
1584: l_inventoryitemid NUMBER;

Line 1581: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE:=NULL;

1577: l_searchable VARCHAR2(1);
1578: l_checkeligibility VARCHAR2(1);
1579: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE;
1580: l_attr_name EGO_ATTRS_V.ATTR_NAME%TYPE:=NULL;
1581: l_attr_disp_name EGO_ATTRS_V.ATTR_DISPLAY_NAME%TYPE:=NULL;
1582: l_data_type VARCHAR2(1);
1583: l_display VARCHAR2(1);
1584: l_inventoryitemid NUMBER;
1585: l_revisionid NUMBER;

Line 2835: --- get data_type_code from ego_attrs_v for l_ATTRID

2831: IF(get_ICC_TA_metadata_rec.ATTR_ID is not null ) THEN
2832: l_ATTRID := get_ICC_TA_metadata_rec.ATTR_ID ;
2833:
2834: -- fix for bug 14851479 trudave
2835: --- get data_type_code from ego_attrs_v for l_ATTRID
2836:
2837: SELECT DATA_TYPE_CODE INTO l_data_type_code
2838: FROM EGO_ATTRS_V
2839: WHERE ATTR_ID = l_attrid;

Line 2838: FROM EGO_ATTRS_V

2834: -- fix for bug 14851479 trudave
2835: --- get data_type_code from ego_attrs_v for l_ATTRID
2836:
2837: SELECT DATA_TYPE_CODE INTO l_data_type_code
2838: FROM EGO_ATTRS_V
2839: WHERE ATTR_ID = l_attrid;
2840:
2841: END IF;
2842: