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_TRANS_ATTR_VERS_B

Line 85: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE;

81: l_programapplicationid NUMBER;
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);

Line 395: INSERT INTO EGO_TRANS_ATTR_VERS_B

391:
392: /* INSERTING values in tables*/
393: BEGIN
394:
395: INSERT INTO EGO_TRANS_ATTR_VERS_B
396: (association_id,attr_id,icc_version_number,attr_display_name,"SEQUENCE",value_set_id,uom_class,
397: default_value,rejected_value,required_flag,readonly_flag,hidden_flag, searchable_flag,
398: check_eligibility,inventory_item_id,organization_id, revision_id,metadata_level,created_by,
399: creation_date,last_updated_by,last_update_date,last_update_login,program_application_id,

Line 570: EGO_TRANS_ATTR_VERS_B versions ,

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 ,
573: LEVEL lev
574: FROM mtl_item_catalog_groups_b START

Line 636: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,

632: versions.attr_display_name ,
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

Line 717: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,

713: versions.SEQUENCE ,
714: versions.attr_display_name ,
715: versions.metadata_level ,
716: Hier.lev
717: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
718: (SELECT ITEM_CATALOG_GROUP_ID ,
719: LEVEL LEV
720: FROM MTL_ITEM_CATALOG_GROUPS_B
721: START WITH ITEM_CATALOG_GROUP_ID = p_item_cat_group_id

Line 875: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE;

871: l_readonlyflag VARCHAR2(1);
872: l_hiddenflag VARCHAR2(1);
873: l_searchable VARCHAR2(1);
874: l_checkeligibility VARCHAR2(1);
875: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE;
876: l_metadatalevel VARCHAR2(10);
877: l_attr_disp_name VARCHAR2(80);
878:
879: indexcount NUMBER:=1;

Line 904: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,

900: VERSIONS.HIDDEN_FLAG ,
901: VERSIONS.SEARCHABLE_FLAG ,
902: VERSIONS.CHECK_ELIGIBILITY ,
903: Hier.lev
904: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
905: (SELECT ITEM_CATALOG_GROUP_ID ,
906: LEVEL LEV
907: FROM MTL_ITEM_CATALOG_GROUPS_B
908: START WITH ITEM_CATALOG_GROUP_ID = CP_ITEM_CAT_GROUP_ID

Line 1318: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE;

1314: l_programapplicationid NUMBER;
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);

Line 1412: INSERT INTO EGO_TRANS_ATTR_VERS_B

1408: IF(l_attr_disp_name IS NOT NULL OR l_default_value IS NOT NULL OR l_rejectedvalue IS NOT NULL OR l_required IS NOT NULL OR
1409: l_readonlyflag IS NOT NULL OR l_hiddenflag IS NOT NULL OR l_searchable IS NOT NULL OR l_checkeligibility IS NOT NULL ) THEN
1410: /* INSERTING values in tables*/
1411: BEGIN
1412: INSERT INTO EGO_TRANS_ATTR_VERS_B
1413: (association_id,
1414: attr_id,
1415: icc_version_number,
1416: attr_display_name,

Line 1579: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE;

1575: l_readonlyflag VARCHAR2(1);
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);

Line 1644: UPDATE EGO_TRANS_ATTR_VERS_B

1640: RAISE e_ta_disp_name_exist;
1641: END IF;
1642:
1643: IF(l_inventoryitemid IS NOT NULL AND l_revisionid IS NOT NULL AND l_organizationid IS NOT NULL ) THEN
1644: UPDATE EGO_TRANS_ATTR_VERS_B
1645: SET "SEQUENCE" =l_attr_sequence,
1646: ATTR_DISPLAY_NAME = l_attr_disp_name,
1647: value_set_id = l_value_set_id,
1648: uom_class = l_uom_class,

Line 1666: UPDATE EGO_TRANS_ATTR_VERS_B

1662: AND ORGANIZATION_ID = l_organizationid
1663: AND REVISION_ID = l_revisionid
1664: AND metadata_level = 'ITM';
1665: ELSE
1666: UPDATE EGO_TRANS_ATTR_VERS_B
1667: SET "SEQUENCE" =l_attr_sequence,
1668: ATTR_DISPLAY_NAME = l_attr_disp_name,
1669: value_set_id = l_value_set_id,
1670: uom_class = l_uom_class,

Line 1771: DELETE FROM EGO_TRANS_ATTR_VERS_B

1767:
1768: BEGIN
1769: --Reset all global variables
1770: FND_MSG_PUB.Initialize;
1771: DELETE FROM EGO_TRANS_ATTR_VERS_B
1772: WHERE ASSOCIATION_ID= p_association_id
1773: AND ATTR_ID =p_attr_id
1774: AND ICC_VERSION_NUMBER=0;
1775: x_return_status := G_STATUS_SUCCESS;

Line 1800: l_association_id EGO_TRANS_ATTR_VERS_B.ASSOCIATION_ID%TYPE;

1796: x_msg_count OUT NOCOPY NUMBER,
1797: x_msg_data OUT NOCOPY VARCHAR2) IS
1798:
1799: /* Declaring local parameters*/
1800: l_association_id EGO_TRANS_ATTR_VERS_B.ASSOCIATION_ID%TYPE;
1801: l_attr_id EGO_TRANS_ATTR_VERS_B.ATTR_ID%TYPE;
1802: l_icc_version_number NUMBER;
1803:
1804: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE;

Line 1801: l_attr_id EGO_TRANS_ATTR_VERS_B.ATTR_ID%TYPE;

1797: x_msg_data OUT NOCOPY VARCHAR2) IS
1798:
1799: /* Declaring local parameters*/
1800: l_association_id EGO_TRANS_ATTR_VERS_B.ASSOCIATION_ID%TYPE;
1801: l_attr_id EGO_TRANS_ATTR_VERS_B.ATTR_ID%TYPE;
1802: l_icc_version_number NUMBER;
1803:
1804: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE;
1805: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Transaction_Attribute';

Line 1804: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE;

1800: l_association_id EGO_TRANS_ATTR_VERS_B.ASSOCIATION_ID%TYPE;
1801: l_attr_id EGO_TRANS_ATTR_VERS_B.ATTR_ID%TYPE;
1802: l_icc_version_number NUMBER;
1803:
1804: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE;
1805: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Transaction_Attribute';
1806:
1807: BEGIN
1808: --Reset all global variables

Line 1815: DELETE FROM EGO_TRANS_ATTR_VERS_B

1811: LOOP
1812: l_association_id := p_tran_attrs_tbl(i).associationid;
1813: l_attr_id := p_tran_attrs_tbl(i).attrid;
1814:
1815: DELETE FROM EGO_TRANS_ATTR_VERS_B
1816: WHERE ASSOCIATION_ID= l_association_id
1817: AND ATTR_ID =l_attr_id
1818: AND ICC_VERSION_NUMBER=0;
1819: END LOOP; /* FOR i IN p_tran_attrs_tbl.first..p_tran_attrs_tbl.last */

Line 1853: --l_association_id EGO_TRANS_ATTR_VERS_B.ASSOCIATION_ID%TYPE;

1849: ,x_msg_data OUT NOCOPY VARCHAR2)
1850: IS
1851:
1852: /* Declaring local parameters*/
1853: --l_association_id EGO_TRANS_ATTR_VERS_B.ASSOCIATION_ID%TYPE;
1854: --l_attr_id EGO_TRANS_ATTR_VERS_B.ATTR_ID%TYPE;
1855: l_icc_version_number NUMBER:=p_version_number;
1856: l_max_ver_number NUMBER:=0;
1857: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE:=p_icc_id;

Line 1854: --l_attr_id EGO_TRANS_ATTR_VERS_B.ATTR_ID%TYPE;

1850: IS
1851:
1852: /* Declaring local parameters*/
1853: --l_association_id EGO_TRANS_ATTR_VERS_B.ASSOCIATION_ID%TYPE;
1854: --l_attr_id EGO_TRANS_ATTR_VERS_B.ATTR_ID%TYPE;
1855: l_icc_version_number NUMBER:=p_version_number;
1856: l_max_ver_number NUMBER:=0;
1857: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE:=p_icc_id;
1858: l_api_name CONSTANT VARCHAR2(30) := 'Release_Transaction_Attribute';

Line 1857: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE:=p_icc_id;

1853: --l_association_id EGO_TRANS_ATTR_VERS_B.ASSOCIATION_ID%TYPE;
1854: --l_attr_id EGO_TRANS_ATTR_VERS_B.ATTR_ID%TYPE;
1855: l_icc_version_number NUMBER:=p_version_number;
1856: l_max_ver_number NUMBER:=0;
1857: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE:=p_icc_id;
1858: l_api_name CONSTANT VARCHAR2(30) := 'Release_Transaction_Attribute';
1859:
1860: l_return_status VARCHAR2(1);
1861: l_errorcode NUMBER;

Line 1871: FROM EGO_TRANS_ATTR_VERS_B

1867:
1868: CURSOR cur_tran_attr_vers_exist
1869: IS
1870: SELECT Max(icc_version_number) maxver
1871: FROM EGO_TRANS_ATTR_VERS_B
1872: WHERE ITEM_CATALOG_GROUP_ID=l_item_cat_group_id;
1873:
1874: BEGIN
1875: --Reset all global variables

Line 1925: l_association_id EGO_TRANS_ATTR_VERS_B.ASSOCIATION_ID%TYPE;

1921: x_msg_count OUT NOCOPY NUMBER,
1922: x_msg_data OUT NOCOPY VARCHAR2)
1923: IS
1924: /* Declaring local parameters*/
1925: l_association_id EGO_TRANS_ATTR_VERS_B.ASSOCIATION_ID%TYPE;
1926: l_attr_id EGO_TRANS_ATTR_VERS_B.ATTR_ID%TYPE;
1927: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE:=p_item_cat_group_id;
1928: l_icc_version_number NUMBER:=p_version_number;
1929: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Transaction_Attribute';

Line 1926: l_attr_id EGO_TRANS_ATTR_VERS_B.ATTR_ID%TYPE;

1922: x_msg_data OUT NOCOPY VARCHAR2)
1923: IS
1924: /* Declaring local parameters*/
1925: l_association_id EGO_TRANS_ATTR_VERS_B.ASSOCIATION_ID%TYPE;
1926: l_attr_id EGO_TRANS_ATTR_VERS_B.ATTR_ID%TYPE;
1927: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE:=p_item_cat_group_id;
1928: l_icc_version_number NUMBER:=p_version_number;
1929: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Transaction_Attribute';
1930:

Line 1927: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE:=p_item_cat_group_id;

1923: IS
1924: /* Declaring local parameters*/
1925: l_association_id EGO_TRANS_ATTR_VERS_B.ASSOCIATION_ID%TYPE;
1926: l_attr_id EGO_TRANS_ATTR_VERS_B.ATTR_ID%TYPE;
1927: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE:=p_item_cat_group_id;
1928: l_icc_version_number NUMBER:=p_version_number;
1929: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Transaction_Attribute';
1930:
1931: CURSOR cur_tran_attr_vers

Line 1934: FROM EGO_TRANS_ATTR_VERS_B

1930:
1931: CURSOR cur_tran_attr_vers
1932: IS
1933: SELECT *
1934: FROM EGO_TRANS_ATTR_VERS_B
1935: WHERE ITEM_CATALOG_GROUP_ID=l_item_cat_group_id
1936: AND ICC_VERSION_NUMBER =0;
1937: BEGIN
1938: --Reset all global variables

Line 1942: INSERT INTO EGO_TRANS_ATTR_VERS_B

1938: --Reset all global variables
1939: FND_MSG_PUB.Initialize;
1940: FOR i IN cur_tran_attr_vers
1941: LOOP
1942: INSERT INTO EGO_TRANS_ATTR_VERS_B
1943: (association_id,attr_id,icc_version_number,attr_display_name,"SEQUENCE",value_set_id,uom_class,
1944: default_value,rejected_value,required_flag,readonly_flag,hidden_flag, searchable_flag,
1945: check_eligibility,inventory_item_id,organization_id, revision_id,metadata_level,created_by,
1946: creation_date,last_updated_by,last_update_date,last_update_login,program_application_id,

Line 1988: /* l_association_id EGO_TRANS_ATTR_VERS_B.ASSOCIATION_ID%TYPE;

1984: x_msg_data OUT NOCOPY VARCHAR2)
1985: IS
1986: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Transaction_Attribute';
1987: /* Declaring local parameters*/
1988: /* l_association_id EGO_TRANS_ATTR_VERS_B.ASSOCIATION_ID%TYPE;
1989: l_attr_id EGO_TRANS_ATTR_VERS_B.ATTR_ID%TYPE;
1990: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE:=p_item_cat_group_id;
1991: l_icc_version_number NUMBER:=p_version_number;
1992:

Line 1989: l_attr_id EGO_TRANS_ATTR_VERS_B.ATTR_ID%TYPE;

1985: IS
1986: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Transaction_Attribute';
1987: /* Declaring local parameters*/
1988: /* l_association_id EGO_TRANS_ATTR_VERS_B.ASSOCIATION_ID%TYPE;
1989: l_attr_id EGO_TRANS_ATTR_VERS_B.ATTR_ID%TYPE;
1990: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE:=p_item_cat_group_id;
1991: l_icc_version_number NUMBER:=p_version_number;
1992:
1993: CURSOR cur_tran_attr_vers

Line 1990: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE:=p_item_cat_group_id;

1986: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Transaction_Attribute';
1987: /* Declaring local parameters*/
1988: /* l_association_id EGO_TRANS_ATTR_VERS_B.ASSOCIATION_ID%TYPE;
1989: l_attr_id EGO_TRANS_ATTR_VERS_B.ATTR_ID%TYPE;
1990: l_item_cat_group_id EGO_TRANS_ATTR_VERS_B.ITEM_CATALOG_GROUP_ID%TYPE:=p_item_cat_group_id;
1991: l_icc_version_number NUMBER:=p_version_number;
1992:
1993: CURSOR cur_tran_attr_vers
1994: IS

Line 1996: FROM EGO_TRANS_ATTR_VERS_B

1992:
1993: CURSOR cur_tran_attr_vers
1994: IS
1995: SELECT *
1996: FROM EGO_TRANS_ATTR_VERS_B
1997: WHERE ITEM_CATALOG_GROUP_ID=l_item_cat_group_id
1998: AND ICC_VERSION_NUMBER =0;*/
1999: BEGIN
2000: --Reset all global variables

Line 2007: INSERT INTO EGO_TRANS_ATTR_VERS_B

2003: END IF;
2004:
2005:
2006: IF (p_sorce_item_id IS NOT NULL AND p_source_rev_id IS NOT NULL AND p_source_org_id IS NOT NULL ) THEN
2007: INSERT INTO EGO_TRANS_ATTR_VERS_B
2008: (SELECT association_id,attr_id,icc_version_number,attr_display_name,SEQUENCE,value_set_id,uom_class,
2009: default_value,rejected_value,required_flag,readonly_flag,hidden_flag,searchable_flag,
2010: check_eligibility,p_dest_item_id,p_dest_org_id,p_dest_rev_id,'ITM',G_CURRENT_USER_ID,
2011: sysdate,G_CURRENT_USER_ID,SYSDATE,G_CURRENT_LOGIN_ID,program_application_id,

Line 2013: FROM EGO_TRANS_ATTR_VERS_B

2009: default_value,rejected_value,required_flag,readonly_flag,hidden_flag,searchable_flag,
2010: check_eligibility,p_dest_item_id,p_dest_org_id,p_dest_rev_id,'ITM',G_CURRENT_USER_ID,
2011: sysdate,G_CURRENT_USER_ID,SYSDATE,G_CURRENT_LOGIN_ID,program_application_id,
2012: program_id,program_update_date,request_id,item_catalog_group_id
2013: FROM EGO_TRANS_ATTR_VERS_B
2014: WHERE inventory_item_id =p_sorce_item_id
2015: AND organization_id =p_source_org_id
2016: AND revision_id= p_source_rev_id);
2017: /*When icc_id and ver_id is passed*/

Line 2019: INSERT INTO EGO_TRANS_ATTR_VERS_B

2015: AND organization_id =p_source_org_id
2016: AND revision_id= p_source_rev_id);
2017: /*When icc_id and ver_id is passed*/
2018: ELSIF (p_source_icc_id IS NOT NULL AND p_source_ver_no IS NOT NULL) THEN
2019: INSERT INTO EGO_TRANS_ATTR_VERS_B
2020: (SELECT association_id,attr_id,p_dest_ver_no,attr_display_name,SEQUENCE,value_set_id,uom_class,
2021: default_value,rejected_value,required_flag,readonly_flag,hidden_flag,searchable_flag,
2022: check_eligibility,inventory_item_id,organization_id,revision_id,'ICC',G_CURRENT_USER_ID,
2023: sysdate,G_CURRENT_USER_ID,SYSDATE,G_CURRENT_LOGIN_ID,program_application_id,

Line 2025: FROM EGO_TRANS_ATTR_VERS_B

2021: default_value,rejected_value,required_flag,readonly_flag,hidden_flag,searchable_flag,
2022: check_eligibility,inventory_item_id,organization_id,revision_id,'ICC',G_CURRENT_USER_ID,
2023: sysdate,G_CURRENT_USER_ID,SYSDATE,G_CURRENT_LOGIN_ID,program_application_id,
2024: program_id,program_update_date,request_id,p_dest_icc_id
2025: FROM EGO_TRANS_ATTR_VERS_B
2026: WHERE ITEM_CATALOG_GROUP_ID =p_source_icc_id
2027: AND ICC_VERSION_NUMBER = p_source_ver_no);
2028:
2029: END IF;

Line 2065: DELETE FROM EGO_TRANS_ATTR_VERS_B

2061: FND_MSG_PUB.Initialize;
2062: END IF;
2063:
2064:
2065: DELETE FROM EGO_TRANS_ATTR_VERS_B
2066: WHERE ITEM_CATALOG_GROUP_ID = p_source_icc_id
2067: AND ICC_VERSION_NUMBER = 0;
2068:
2069: Copy_Transaction_Attribute (

Line 2181: ' FROM EGO_TRANS_ATTR_VERS_B TA_VERS , '||

2177: ' TA_VERS.ORGANIZATION_ID , '||
2178: ' TA_VERS.REVISION_ID , '||
2179: ' TA_VERS.VALUE_SET_ID , '||
2180: ' HIERLEVEL.lev '||
2181: ' FROM EGO_TRANS_ATTR_VERS_B TA_VERS , '||
2182: ' ( SELECT ITEM_CATALOG_GROUP_ID , '||
2183: ' LEVEL LEV '||
2184: ' FROM MTL_ITEM_CATALOG_GROUPS_B '||
2185: ' START WITH ITEM_CATALOG_GROUP_ID =:1 '||

Line 2331: ' FROM EGO_TRANS_ATTR_VERS_B TA_VERS , '||

2327: ' TA_VERS.ORGANIZATION_ID , '||
2328: ' TA_VERS.REVISION_ID , '||
2329: ' TA_VERS.VALUE_SET_ID , '||
2330: ' HIERLEVEL.lev '||
2331: ' FROM EGO_TRANS_ATTR_VERS_B TA_VERS , '||
2332: ' ( SELECT ITEM_CATALOG_GROUP_ID , '||
2333: ' LEVEL LEV '||
2334: ' FROM MTL_ITEM_CATALOG_GROUPS_B '||
2335: ' START WITH ITEM_CATALOG_GROUP_ID =:1 '||

Line 2555: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,

2551: VERSIONS.HIDDEN_FLAG ,
2552: VERSIONS.SEARCHABLE_FLAG ,
2553: VERSIONS.CHECK_ELIGIBILITY ,
2554: Hier.lev
2555: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
2556: (SELECT ITEM_CATALOG_GROUP_ID , LEVEL LEV
2557: FROM MTL_ITEM_CATALOG_GROUPS_B START WITH ITEM_CATALOG_GROUP_ID = v_ITEM_CATALOG_GROUP_ID CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID
2558: ) HIER
2559: WHERE HIER.ITEM_CATALOG_GROUP_ID = versions.item_catalog_group_id AND versions.attr_id = v_attr_id )

Line 2629: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,

2625: VERSIONS.HIDDEN_FLAG ,
2626: VERSIONS.SEARCHABLE_FLAG ,
2627: VERSIONS.CHECK_ELIGIBILITY ,
2628: Hier.lev
2629: FROM EGO_TRANS_ATTR_VERS_B VERSIONS,
2630: (SELECT ITEM_CATALOG_GROUP_ID , LEVEL LEV
2631: FROM MTL_ITEM_CATALOG_GROUPS_B START WITH ITEM_CATALOG_GROUP_ID = v_ITEM_CATALOG_GROUP_ID CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID =ITEM_CATALOG_GROUP_ID
2632: ) HIER
2633: WHERE HIER.ITEM_CATALOG_GROUP_ID = versions.item_catalog_group_id AND versions.attr_id = v_attr_id )