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_TA_BULKLOAD_PVT dependencies on EGO_TRANS_ATTR_VERS_B

Line 793: FROM EGO_TRANS_ATTR_VERS_B ETAVB

789: FROM EGO_TRANS_ATTRS_VERS_INTF ETAVT
790: WHERE attr_id IS NOT NULL
791: AND NOT EXISTS (
792: SELECT 1
793: FROM EGO_TRANS_ATTR_VERS_B ETAVB
794: WHERE ETAVB.attr_id = ETAVT.attr_id
795: AND ETAVB.item_catalog_group_id=ETAVT.item_catalog_group_id
796: AND ETAVB.icc_version_number=0)
797: AND ETAVT.transaction_type IN (G_UPDATE,G_DELETE,G_SYNC)

Line 811: FROM EGO_TRANS_ATTR_VERS_B ETAVB

807: ETAVT.last_update_login = G_LOGIN_ID
808: WHERE attr_id IS NOT NULL
809: AND NOT EXISTS (
810: SELECT 1
811: FROM EGO_TRANS_ATTR_VERS_B ETAVB
812: WHERE ETAVB.attr_id = ETAVT.attr_id
813: AND ETAVB.item_catalog_group_id=ETAVT.item_catalog_group_id
814: AND ETAVB.icc_version_number=0)
815: AND ETAVT.transaction_type IN (G_UPDATE,G_DELETE,G_SYNC)

Line 830: FROM EGO_TRANS_ATTR_VERS_B ETAVB

826: last_update_login = G_LOGIN_ID
827: WHERE attr_id IS NOT NULL
828: AND EXISTS (
829: SELECT 1
830: FROM EGO_TRANS_ATTR_VERS_B ETAVB
831: WHERE ETAVB.attr_id = ETAVT.attr_id
832: AND ETAVB.item_catalog_group_id=ETAVT.item_catalog_group_id
833: AND ETAVB.icc_version_number=0)
834: --AND attr_name IS NOT NULL

Line 880: FROM EGO_TRANS_ATTRS_VERS_INTF a,EGO_TRANS_ATTR_VERS_B b

876: nvl(a.check_eligibility,b.check_eligibility),
877: nvl(a.value_set_id,b.value_set_id),
878: nvl(a.attr_display_name,b.attr_display_name),
879: b.sequence
880: FROM EGO_TRANS_ATTRS_VERS_INTF a,EGO_TRANS_ATTR_VERS_B b
881: WHERE a.attr_id=b.attr_id
882: AND a.item_catalog_group_id=b.item_catalog_group_id
883: AND b.icc_version_number=0
884: AND a.attr_id=ETAVT.attr_id)

Line 1109: FROM EGO_TRANS_ATTR_VERS_B ETAVB

1105: AND item_catalog_group_id IS NOT NULL
1106: AND association_id IS NOT NULL
1107: AND NOT EXISTS (
1108: SELECT 1
1109: FROM EGO_TRANS_ATTR_VERS_B ETAVB
1110: WHERE ETAVB.association_id = ETAVT.association_id
1111: AND ETAVB.item_Catalog_group_id= ETAVT.item_Catalog_group_id
1112: AND ETAVB.icc_version_number=0)
1113: AND ETAVT.transaction_type IN (G_UPDATE,G_DELETE,G_SYNC)

Line 1129: FROM EGO_TRANS_ATTR_VERS_B ETAVB

1125: AND item_catalog_group_id IS NOT NULL
1126: AND association_id IS NOT NULL
1127: AND NOT EXISTS (
1128: SELECT 1
1129: FROM EGO_TRANS_ATTR_VERS_B ETAVB
1130: WHERE ETAVB.association_id = ETAVT.association_id
1131: AND ETAVB.item_Catalog_group_id= ETAVT.item_Catalog_group_id
1132: AND ETAVB.icc_version_number=0)
1133: AND transaction_type IN (G_UPDATE,G_DELETE,G_SYNC)

Line 1708: FROM ego_trans_attr_vers_b

1704: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting Attr_Name to Attr_id');
1705: /* Attr_Name to Attr_id conversion */
1706: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1707: SET (attr_id/*,attr_display_name,sequence*/) = ( SELECT attr_id/*,attr_display_name,sequence*/
1708: FROM ego_trans_attr_vers_b
1709: WHERE attr_id IN ( SELECT efdcue.attr_id
1710: FROM fnd_descr_flex_column_usages fdfcu,
1711: ego_fnd_df_col_usgs_ext efdcue
1712: WHERE fdfcu.application_id = efdcue.application_id

Line 1741: FROM EGO_TRANS_ATTR_VERS_B

1737: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting attr display name to attr_id ');
1738: /*attr display name to attr_id conversion*/
1739: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1740: SET attr_id = ( SELECT attr_id
1741: FROM EGO_TRANS_ATTR_VERS_B
1742: WHERE Upper(attr_display_name) = Upper(ETAVT.attr_display_name)
1743: AND item_catalog_group_id=ETAVT.item_catalog_group_id
1744: AND icc_version_number=0
1745: )

Line 1756: FROM EGO_TRANS_ATTR_VERS_B

1752: ego_metadata_bulkload_pvt.Write_debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Converting associaton_id from icc_id,attr_id ');
1753: /* associaton_id from icc_id */
1754: UPDATE EGO_TRANS_ATTRS_VERS_INTF ETAVT
1755: SET association_id = ( SELECT association_id
1756: FROM EGO_TRANS_ATTR_VERS_B
1757: WHERE attr_id= ETAVT.attr_id
1758: AND item_catalog_group_id=ETAVT.item_catalog_group_id
1759: AND icc_version_number=0
1760: )

Line 2087: FROM EGO_TRANS_ATTR_VERS_B

2083: AND p_ta_intf_tbl(i).attr_name IS NOT NULL) THEN
2084:
2085: BEGIN
2086: SELECT attr_id INTO p_ta_intf_tbl(i).attr_id
2087: FROM EGO_TRANS_ATTR_VERS_B
2088: WHERE attr_id IN ( SELECT efdcue.attr_id
2089: FROM fnd_descr_flex_column_usages fdfcu,
2090: ego_fnd_df_col_usgs_ext efdcue
2091: WHERE fdfcu.application_id = efdcue.application_id

Line 2141: FROM EGO_TRANS_ATTR_VERS_B

2137: THEN /* resolved sync and get the attr_id in previour attr_name to attr_id*/
2138:
2139: BEGIN
2140: SELECT attr_id INTO p_ta_intf_tbl(i).attr_id
2141: FROM EGO_TRANS_ATTR_VERS_B
2142: WHERE Upper(attr_display_name) = Upper(p_ta_intf_tbl(i).attr_display_name)
2143: AND item_catalog_group_id=p_ta_intf_tbl(i).item_catalog_group_id
2144: AND icc_version_number=0;
2145:

Line 2178: FROM EGO_TRANS_ATTR_VERS_B

2174: AND p_ta_intf_tbl(i).association_id is NULL) THEN
2175:
2176: BEGIN
2177: SELECT association_id INTO p_ta_intf_tbl(i).association_id
2178: FROM EGO_TRANS_ATTR_VERS_B
2179: WHERE attr_id= p_ta_intf_tbl(i).attr_id
2180: AND item_catalog_group_id= p_ta_intf_tbl(i).item_catalog_group_id
2181: AND icc_version_number=0;
2182:

Line 2312: FROM EGO_TRANS_ATTR_VERS_B ETAVB

2308: IF (p_ta_intf_tbl(i).attr_id IS NOT NULL) THEN
2309:
2310: BEGIN
2311: SELECT attr_id INTO l_id_exists
2312: FROM EGO_TRANS_ATTR_VERS_B ETAVB
2313: WHERE ETAVB.attr_id = p_ta_intf_tbl(i).attr_id
2314: AND item_catalog_group_id=p_ta_intf_tbl(i).item_catalog_group_id
2315: AND icc_version_number=0;
2316:

Line 2342: FROM EGO_TRANS_ATTR_VERS_B b

2338: p_ta_intf_tbl(i).uom_class,p_ta_intf_tbl(i).default_value,p_ta_intf_tbl(i).rejected_value,
2339: p_ta_intf_tbl(i).required_flag,p_ta_intf_tbl(i).readonly_flag,p_ta_intf_tbl(i).hidden_flag,
2340: p_ta_intf_tbl(i).searchable_flag, p_ta_intf_tbl(i).check_eligibility,
2341: p_ta_intf_tbl(i).value_set_id,p_ta_intf_tbl(i).attr_display_name,p_ta_intf_tbl(i).SEQUENCE
2342: FROM EGO_TRANS_ATTR_VERS_B b
2343: WHERE b.item_catalog_group_id=p_ta_intf_tbl(i).item_catalog_group_id
2344: AND b.icc_version_number=0
2345: AND b.attr_id= p_ta_intf_tbl(i).attr_id;
2346:

Line 2385: FROM EGO_TRANS_ATTR_VERS_B ETAVB

2381: IF ( p_ta_intf_tbl(i).association_id IS NOT NULL AND p_ta_intf_tbl(i).attr_id IS NOT NULL AND p_ta_intf_tbl(i).item_catalog_group_id IS NOT NULL) THEN
2382:
2383: BEGIN
2384: SELECT association_id INTO l_id_exists
2385: FROM EGO_TRANS_ATTR_VERS_B ETAVB
2386: WHERE ETAVB.association_id = p_ta_intf_tbl(i).association_id
2387: AND item_catalog_group_id= p_ta_intf_tbl(i).item_catalog_group_id
2388: AND icc_version_number=0
2389: AND attr_id=p_ta_intf_tbl(i).attr_id;

Line 2595: l_attr_id ego_trans_attr_vers_b.attr_id%TYPE;

2591: x_association_id OUT NOCOPY NUMBER) RETURN BOOLEAN IS
2592:
2593: l_start_date ego_mtl_catalog_grp_vers_b.start_active_date%TYPE;
2594: l_latest_vers ego_mtl_catalog_grp_vers_b.version_seq_id%TYPE;
2595: l_attr_id ego_trans_attr_vers_b.attr_id%TYPE;
2596: l_association_id ego_trans_attr_vers_b.association_id%TYPE;
2597: l_proc_name CONSTANT VARCHAR2(30) := 'IS_INHERITED_ATTRIBUTE';
2598:
2599: CURSOR c_parents IS

Line 2596: l_association_id ego_trans_attr_vers_b.association_id%TYPE;

2592:
2593: l_start_date ego_mtl_catalog_grp_vers_b.start_active_date%TYPE;
2594: l_latest_vers ego_mtl_catalog_grp_vers_b.version_seq_id%TYPE;
2595: l_attr_id ego_trans_attr_vers_b.attr_id%TYPE;
2596: l_association_id ego_trans_attr_vers_b.association_id%TYPE;
2597: l_proc_name CONSTANT VARCHAR2(30) := 'IS_INHERITED_ATTRIBUTE';
2598:
2599: CURSOR c_parents IS
2600: SELECT heir.item_catalog_group_id,

Line 2615: FROM ego_trans_attr_vers_b ta,

2611: CURSOR c(c_item_catalog_group_id IN NUMBER,
2612: c_latest_ver IN NUMBER) IS
2613: SELECT ta.attr_id,
2614: ta.association_id
2615: FROM ego_trans_attr_vers_b ta,
2616: ego_fnd_df_col_usgs_ext attr ,
2617: fnd_descr_flex_column_usages flex_col
2618: WHERE 1=1
2619: AND ta.metadata_level = 'ICC'

Line 2688: l_attr_id ego_trans_attr_vers_b.attr_id%TYPE; -- bug 9980051

2684:
2685: l_is_child_icc NUMBER;
2686: l_is_ta_there NUMBER;
2687: l_inherited BOOLEAN; -- bug 9980051
2688: l_attr_id ego_trans_attr_vers_b.attr_id%TYPE; -- bug 9980051
2689: l_association_id ego_trans_attr_vers_b.association_id%TYPE; -- bug 9980051
2690: e_ta_int_name_exist EXCEPTION;
2691: e_ta_disp_name_exist EXCEPTION;
2692: e_ta_sequence_exist EXCEPTION;

Line 2689: l_association_id ego_trans_attr_vers_b.association_id%TYPE; -- bug 9980051

2685: l_is_child_icc NUMBER;
2686: l_is_ta_there NUMBER;
2687: l_inherited BOOLEAN; -- bug 9980051
2688: l_attr_id ego_trans_attr_vers_b.attr_id%TYPE; -- bug 9980051
2689: l_association_id ego_trans_attr_vers_b.association_id%TYPE; -- bug 9980051
2690: e_ta_int_name_exist EXCEPTION;
2691: e_ta_disp_name_exist EXCEPTION;
2692: e_ta_sequence_exist EXCEPTION;
2693:

Line 2844: FROM EGO_TRANS_ATTR_VERS_B

2840: IF l_is_child_icc=1 THEN
2841:
2842: BEGIN /* Checking is TA thre for same icc, iccversion*/
2843: SELECT 1 INTO l_is_ta_there
2844: FROM EGO_TRANS_ATTR_VERS_B
2845: WHERE item_catalog_group_id=p_ta_intf_rec.item_catalog_group_id
2846: AND icc_version_number=p_ta_intf_rec.icc_version_number
2847: AND attr_id= p_ta_intf_rec.attr_id;
2848:

Line 3104: EGO_TRANS_ATTR_VERS_B versions ,

3100: hier.lev
3101: FROM ego_obj_AG_assocs_b assocs ,
3102: ego_attrs_v attrs ,
3103: ego_attr_groups_v ag ,
3104: EGO_TRANS_ATTR_VERS_B versions ,
3105: mtl_item_catalog_groups_kfv icv ,
3106: (SELECT item_catalog_group_id ,
3107: LEVEL lev
3108: FROM mtl_item_catalog_groups_b START

Line 3170: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,

3166: versions.attr_display_name ,
3167: versions.metadata_level ,
3168: attrs.attr_name ,
3169: Hier.lev
3170: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
3171: EGO_ATTRS_V ATTRS ,
3172: (SELECT ITEM_CATALOG_GROUP_ID ,
3173: LEVEL LEV
3174: FROM MTL_ITEM_CATALOG_GROUPS_B START

Line 3251: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,

3247: versions.SEQUENCE ,
3248: versions.attr_display_name ,
3249: versions.metadata_level ,
3250: Hier.lev
3251: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
3252: (SELECT ITEM_CATALOG_GROUP_ID ,
3253: LEVEL LEV
3254: FROM MTL_ITEM_CATALOG_GROUPS_B
3255: START WITH ITEM_CATALOG_GROUP_ID = p_item_cat_group_id