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 305: FROM EGO_ATTR_GROUPS_DL_V AG

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

Line 339: EGO_ATTR_GROUPS_DL_V AG

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

Line 384: EGO_ATTR_GROUPS_DL_V AGV

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

Line 433: EGO_ATTR_GROUPS_DL_V AGV

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

Line 478: EGO_ATTR_GROUPS_DL_V AGV

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

Line 512: EGO_ATTR_GROUPS_DL_V AG

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

Line 558: EGO_ATTR_GROUPS_DL_V AGV

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

Line 609: EGO_ATTR_GROUPS_DL_V AGV

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

Line 655: EGO_ATTR_GROUPS_DL_V AGV

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

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

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

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

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

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

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