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_ITEM_BULKLOAD_PKG dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 1060: FROM MTL_ITEM_CATALOG_GROUPS_B

1056: FUNCTION get_desc_gen_method(p_catalog_group_id NUMBER) RETURN VARCHAR2
1057: IS
1058: CURSOR c_cat_grp(c_catalog_group_id NUMBER) IS
1059: SELECT ITEM_DESC_GEN_METHOD, ITEM_CATALOG_GROUP_ID, LEVEL
1060: FROM MTL_ITEM_CATALOG_GROUPS_B
1061: WHERE LEVEL > 1
1062: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
1063: START WITH ITEM_CATALOG_GROUP_ID = c_catalog_group_id
1064: ORDER BY LEVEL;

Line 1073: FROM MTL_ITEM_CATALOG_GROUPS_B

1069: -----------------------------------------------------------------------
1070: -- Get the description generation method for catalog category itself --
1071: -----------------------------------------------------------------------
1072: SELECT ITEM_DESC_GEN_METHOD into l_desc_gen_method
1073: FROM MTL_ITEM_CATALOG_GROUPS_B
1074: WHERE ITEM_CATALOG_GROUP_ID = p_catalog_group_id;
1075:
1076: ------------------------------------------------------------------------
1077: -- If the generation method is I i.e. inherit from parent, then check --

Line 1639: l_dyn_sql := l_dyn_sql || ' FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG ';

1635: l_dyn_sql := ' UPDATE EGO_BULKLOAD_INTF EBI';
1636: l_dyn_sql := l_dyn_sql || ' SET '||G_ITEM_CATALOG_EBI_COL||' = ';
1637: l_dyn_sql := l_dyn_sql || '( ';
1638: l_dyn_sql := l_dyn_sql || ' SELECT TO_CHAR(MICG.ITEM_CATALOG_GROUP_ID) ';
1639: l_dyn_sql := l_dyn_sql || ' FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG ';
1640: l_dyn_sql := l_dyn_sql || ' WHERE MICG.CONCATENATED_SEGMENTS = EBI.'||l_item_catalog_name_col;
1641: l_dyn_sql := l_dyn_sql || ') ';
1642: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
1643: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_item_catalog_name_col||' IS NOT NULL';

Line 1748: ' FROM MTL_ITEM_CATALOG_GROUPS_B '||

1744: ' THEN LPAD(LEVEL, 8, ''0'')||''XX'' '||
1745: ' ELSE NULL ' ||
1746: ' END )'||
1747: ' )'||
1748: ' FROM MTL_ITEM_CATALOG_GROUPS_B '||
1749: ' CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID ';
1750: ***/
1751: --
1752: -- R12C changes Tag_Function_Gen_Item_Nums with item_num as $$FG-transaction_id

Line 1764: ' FROM mtl_item_catalog_groups_b '||

1760: ' AND UPPER(ebi.transaction_type) IN (''CREATE'',''SYNC'') '||
1761: ' AND process_status = 1'||
1762: ' AND ''F'' = '||
1763: ' ( SELECT item_num_gen_method'||
1764: ' FROM mtl_item_catalog_groups_b '||
1765: ' WHERE NVL(item_num_gen_method,''I'') IN (''U'',''S'', ''F'') '||
1766: ' AND ROWNUM = 1 '||
1767: ' CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID';
1768: IF G_CATALOG_GROUP_ID IS NULL THEN

Line 1795: ' FROM mtl_item_catalog_groups_b '||

1791: ' AND UPPER(ebi.transaction_type) IN (''CREATE'',''SYNC'') '||
1792: ' AND process_status = 1'||
1793: ' AND ''S'' = '||
1794: ' ( SELECT item_num_gen_method'||
1795: ' FROM mtl_item_catalog_groups_b '||
1796: ' WHERE NVL(item_num_gen_method,''I'') IN (''U'',''S'', ''F'') '||
1797: ' AND ROWNUM = 1 '||
1798: ' CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID';
1799: IF G_CATALOG_GROUP_ID IS NULL THEN

Line 1917: -- l_dyn_sql := l_dyn_sql || ' FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG, EGO_BULKLOAD_INTF EBI ';

1913: -- l_dyn_sql := l_dyn_sql || ' SET (MSII.ITEM_CATALOG_GROUP_ID, MSII.PROCESS_FLAG)=';
1914: -- l_dyn_sql := l_dyn_sql || '( ';
1915: -- l_dyn_sql := l_dyn_sql || ' SELECT MICG.ITEM_CATALOG_GROUP_ID ';
1916: -- l_dyn_sql := l_dyn_sql || ' , DECODE(NVL(MICG.ITEM_CATALOG_GROUP_ID, -1), -1,'||G_ITEM_CATALOG_NAME_ERR_STS||', ' || G_PROCESS_STATUS || ' ) ';
1917: -- l_dyn_sql := l_dyn_sql || ' FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG, EGO_BULKLOAD_INTF EBI ';
1918: -- l_dyn_sql := l_dyn_sql || ' WHERE MICG.CONCATENATED_SEGMENTS(+) = EBI.'||l_intf_col_name_tbl(i);
1919: -- l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';
1920: -- l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
1921: -- ----------------------------------------------------------------------------------

Line 2601: l_dyn_sql := l_dyn_sql || ' FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG, EGO_BULKLOAD_INTF EBI ';

2597: /* option 2 (commented for now) : use if option 1 does not work. fetch the icc_id and set it
2598: l_dyn_sql := l_dyn_sql || ' , MSII.ITEM_CATALOG_GROUP_ID = ';
2599: l_dyn_sql := l_dyn_sql || ' ( ';
2600: l_dyn_sql := l_dyn_sql || ' SELECT MICG.ITEM_CATALOG_GROUP_ID ';
2601: l_dyn_sql := l_dyn_sql || ' FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG, EGO_BULKLOAD_INTF EBI ';
2602: l_dyn_sql := l_dyn_sql || ' WHERE MICG.CONCATENATED_SEGMENTS(+) = EBI.'||l_intf_col_name_tbl(i);
2603: l_dyn_sql := l_dyn_sql || ' ) ';
2604: */
2605: END IF;

Line 3696: l_dyn_sql := l_dyn_sql || ' FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG ';

3692: l_dyn_sql := ' UPDATE EGO_BULKLOAD_INTF EBI';
3693: l_dyn_sql := l_dyn_sql || ' SET '||G_ITEM_CATALOG_EBI_COL||' = ';
3694: l_dyn_sql := l_dyn_sql || '( ';
3695: l_dyn_sql := l_dyn_sql || ' SELECT TO_CHAR(MICG.ITEM_CATALOG_GROUP_ID) ';
3696: l_dyn_sql := l_dyn_sql || ' FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG ';
3697: l_dyn_sql := l_dyn_sql || ' WHERE MICG.CONCATENATED_SEGMENTS = EBI.'||l_item_catalog_name_col;
3698: l_dyn_sql := l_dyn_sql || ') ';
3699: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
3700: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_item_catalog_name_col||' IS NOT NULL';