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_BATCH_COMPARE_PVT dependencies on EGO_ATTR_GROUPS_DL_V

Line 286: EGO_ATTR_GROUPS_DL_V AG ,

282: A.VALUE_SET_ID,
283: A.DATA_TYPE_CODE,
284: A.UOM_CLASS
285: FROM
286: EGO_ATTR_GROUPS_DL_V AG ,
287: EGO_ATTRS_V A
288: WHERE A.ATTR_GROUP_TYPE = AG.ATTR_GROUP_TYPE
289: AND A.ATTR_GROUP_TYPE = 'EGO_MASTER_ITEMS'
290: AND A.ATTR_GROUP_NAME = AG.ATTR_GROUP_NAME

Line 304: FROM EGO_ATTR_GROUPS_DL_V AG

300: CURSOR cr_op_attr_grps IS
301: SELECT
302: AG.ATTR_GROUP_ID,
303: AG.ATTR_GROUP_NAME
304: FROM EGO_ATTR_GROUPS_DL_V AG
305: WHERE AG.ATTR_GROUP_TYPE IN ('EGO_MASTER_ITEMS')
306: AND AG.ATTR_GROUP_NAME <> 'Main'
307: AND AG.APPLICATION_ID = 431 ;
308:

Line 338: EGO_ATTR_GROUPS_DL_V AG

334: AG.ATTR_GROUP_ID,
335: AG.VIEW_PRIVILEGE_ID
336: FROM
337: EGO_ITM_USR_ATTR_INTRFC I,
338: EGO_ATTR_GROUPS_DL_V AG
339: WHERE NVL(AG.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP') = 'EGO_ITEMMGMT_GROUP'
340: AND I.SOURCE_SYSTEM_ID = p_ss_code
341: AND I.SOURCE_SYSTEM_REFERENCE = p_ss_record
342: AND I.DATA_SET_ID = p_batch_id

Line 383: EGO_ATTR_GROUPS_DL_V AGV

379: AV.UOM_CLASS
380: FROM
381: EGO_ITM_USR_ATTR_INTRFC I,
382: EGO_ATTRS_V AV,
383: EGO_ATTR_GROUPS_DL_V AGV
384: WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
385: AND AV.ATTR_NAME = I.ATTR_INT_NAME
386: AND AV.ATTR_GROUP_NAME = I.ATTR_GROUP_INT_NAME
387: AND I.ATTR_GROUP_INT_NAME = p_attr_group_int_name

Line 432: EGO_ATTR_GROUPS_DL_V AGV

428: AV.DATA_TYPE_CODE
429: FROM
430: EGO_ITM_USR_ATTR_INTRFC I,
431: EGO_ATTRS_V AV,
432: EGO_ATTR_GROUPS_DL_V AGV
433: WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
434: AND AV.ATTR_NAME = I.ATTR_INT_NAME
435: AND AV.ATTR_GROUP_NAME = I.ATTR_GROUP_INT_NAME
436: AND I.ATTR_GROUP_INT_NAME = p_attr_group_int_name

Line 477: EGO_ATTR_GROUPS_DL_V AGV

473: AV.UOM_CLASS
474: FROM
475: EGO_ITM_USR_ATTR_INTRFC I,
476: EGO_ATTRS_V AV,
477: EGO_ATTR_GROUPS_DL_V AGV
478: WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
479: AND AGV.ATTR_GROUP_TYPE = 'EGO_ITEM_GTIN_ATTRS'
480: AND AV.ATTR_NAME = I.ATTR_INT_NAME
481: AND AV.ATTR_GROUP_NAME = I.ATTR_GROUP_INT_NAME

Line 511: EGO_ATTR_GROUPS_DL_V AG

507: AG.ATTR_GROUP_ID,
508: AG.VIEW_PRIVILEGE_ID
509: FROM
510: EGO_ITM_USR_ATTR_INTRFC I,
511: EGO_ATTR_GROUPS_DL_V AG
512: WHERE NVL(AG.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP') = 'EGO_ITEMMGMT_GROUP'
513: AND ((I.INVENTORY_ITEM_ID IS NOT NULL AND I.INVENTORY_ITEM_ID = p_item1)
514: OR
515: (I.ITEM_NUMBER IS NOT NULL AND I.ITEM_NUMBER = p_ss_record)

Line 557: EGO_ATTR_GROUPS_DL_V AGV

553: AV.UOM_CLASS
554: FROM
555: EGO_ITM_USR_ATTR_INTRFC I,
556: EGO_ATTRS_V AV,
557: EGO_ATTR_GROUPS_DL_V AGV
558: WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
559: AND ((I.INVENTORY_ITEM_ID IS NOT NULL AND I.INVENTORY_ITEM_ID = p_item1)
560: OR
561: (I.ITEM_NUMBER IS NOT NULL AND I.ITEM_NUMBER = p_ss_record)

Line 608: EGO_ATTR_GROUPS_DL_V AGV

604: AV.UOM_CLASS
605: FROM
606: EGO_ITM_USR_ATTR_INTRFC I,
607: EGO_ATTRS_V AV,
608: EGO_ATTR_GROUPS_DL_V AGV
609: WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
610: AND AV.ATTR_NAME = I.ATTR_INT_NAME
611: AND AV.ATTR_GROUP_NAME = I.ATTR_GROUP_INT_NAME
612: AND I.ATTR_GROUP_INT_NAME = c_attr_group_int_name

Line 654: EGO_ATTR_GROUPS_DL_V AGV

650: AV.UOM_CLASS
651: FROM
652: EGO_ITM_USR_ATTR_INTRFC I,
653: EGO_ATTRS_V AV,
654: EGO_ATTR_GROUPS_DL_V AGV
655: WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
656: AND AGV.ATTR_GROUP_TYPE = 'EGO_ITEM_GTIN_ATTRS'
657: AND AV.ATTR_NAME = I.ATTR_INT_NAME
658: AND AV.ATTR_GROUP_NAME = I.ATTR_GROUP_INT_NAME

Line 1653: l_sql_query := ' FROM EGO_MTL_SY_ITEMS_EXT_VL I, EGO_ATTR_GROUPS_DL_V AG '||

1649: -- For Each attribute Group selected. Get all the attributes in it and
1650: -- Populate the l_compare_table for these attributes
1651: -- The cusor cr_usr_intf_pdh returns
1652: -- Also Perparing Query clause to query for same attributes over other Items.
1653: l_sql_query := ' FROM EGO_MTL_SY_ITEMS_EXT_VL I, EGO_ATTR_GROUPS_DL_V AG '||
1654: ' WHERE AG.APPLICATION_ID = 431 '||
1655: ' AND NVL(AG.ATTR_GROUP_TYPE, ''EGO_ITEMMGMT_GROUP'') = ''EGO_ITEMMGMT_GROUP'' '||
1656: ' AND AG.ATTR_GROUP_ID = I.ATTR_GROUP_ID'||
1657: ' AND I.DATA_LEVEL_ID = :98' || -- Added for R12C: Data_level_id

Line 1773: l_sql_query := ' FROM EGO_MTL_SY_ITEMS_EXT_VL I, EGO_ATTR_GROUPS_DL_V AG, MTL_ITEM_REVISIONS_B REV'||

1769: ' AND I.INVENTORY_ITEM_ID = :1'||
1770: ' AND I.ORGANIZATION_ID = :2';
1771: ELSE --IF rec_attr.REVISION IS NULL THEN
1772: -- If there are attributes with Revisions ... Get Attributes in for given Attribute Group.
1773: l_sql_query := ' FROM EGO_MTL_SY_ITEMS_EXT_VL I, EGO_ATTR_GROUPS_DL_V AG, MTL_ITEM_REVISIONS_B REV'||
1774: ' WHERE AG.APPLICATION_ID = 431 '||
1775: ' AND NVL(AG.ATTR_GROUP_TYPE, ''EGO_ITEMMGMT_GROUP'') = ''EGO_ITEMMGMT_GROUP'' '||
1776: ' AND AG.ATTR_GROUP_ID = I.ATTR_GROUP_ID'||
1777: ' AND I.INVENTORY_ITEM_ID = REV.INVENTORY_ITEM_ID ' ||

Line 2063: l_sql_query :=' FROM EGO_MTL_SY_ITEMS_EXT_VL I, EGO_ATTR_GROUPS_DL_V AG '||

2059: l_temp_query := NULL;
2060: l_idx := 1;
2061: l_start := NVL(l_compare_tbl.LAST,0);
2062: cr_ud_attr := dbms_sql.open_cursor;
2063: l_sql_query :=' FROM EGO_MTL_SY_ITEMS_EXT_VL I, EGO_ATTR_GROUPS_DL_V AG '||
2064: ' WHERE AG.APPLICATION_ID = 431 '||
2065: ' AND NVL(AG.ATTR_GROUP_TYPE, ''EGO_ITEMMGMT_GROUP'') = ''EGO_ITEMMGMT_GROUP'' '||
2066: ' AND AG.ATTR_GROUP_ID = I.ATTR_GROUP_ID'||
2067: ' AND I.DATA_LEVEL_ID = :98' || -- Added for R12C: Data_level_id