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 1023: FROM MTL_ITEM_CATALOG_GROUPS_B

1019: FUNCTION get_desc_gen_method(p_catalog_group_id NUMBER) RETURN VARCHAR2
1020: IS
1021: CURSOR c_cat_grp(c_catalog_group_id NUMBER) IS
1022: SELECT ITEM_DESC_GEN_METHOD, ITEM_CATALOG_GROUP_ID, LEVEL
1023: FROM MTL_ITEM_CATALOG_GROUPS_B
1024: WHERE LEVEL > 1
1025: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
1026: START WITH ITEM_CATALOG_GROUP_ID = c_catalog_group_id
1027: ORDER BY LEVEL;

Line 1036: FROM MTL_ITEM_CATALOG_GROUPS_B

1032: -----------------------------------------------------------------------
1033: -- Get the description generation method for catalog category itself --
1034: -----------------------------------------------------------------------
1035: SELECT ITEM_DESC_GEN_METHOD into l_desc_gen_method
1036: FROM MTL_ITEM_CATALOG_GROUPS_B
1037: WHERE ITEM_CATALOG_GROUP_ID = p_catalog_group_id;
1038:
1039: ------------------------------------------------------------------------
1040: -- If the generation method is I i.e. inherit from parent, then check --

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

1571: l_dyn_sql := ' UPDATE EGO_BULKLOAD_INTF EBI';
1572: l_dyn_sql := l_dyn_sql || ' SET '||G_ITEM_CATALOG_EBI_COL||' = ';
1573: l_dyn_sql := l_dyn_sql || '( ';
1574: l_dyn_sql := l_dyn_sql || ' SELECT TO_CHAR(MICG.ITEM_CATALOG_GROUP_ID) ';
1575: l_dyn_sql := l_dyn_sql || ' FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG ';
1576: l_dyn_sql := l_dyn_sql || ' WHERE MICG.CONCATENATED_SEGMENTS = EBI.'||l_item_catalog_name_col;
1577: l_dyn_sql := l_dyn_sql || ') ';
1578: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
1579: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_item_catalog_name_col||' IS NOT NULL';

Line 1683: ' FROM MTL_ITEM_CATALOG_GROUPS_B '||

1679: ' THEN LPAD(LEVEL, 8, ''0'')||''XX'' '||
1680: ' ELSE NULL ' ||
1681: ' END )'||
1682: ' )'||
1683: ' FROM MTL_ITEM_CATALOG_GROUPS_B '||
1684: ' CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID ';
1685: ***/
1686: --
1687: -- R12C changes Tag_Function_Gen_Item_Nums with item_num as $$FG-transaction_id

Line 1699: ' FROM mtl_item_catalog_groups_b '||

1695: ' AND UPPER(ebi.transaction_type) IN (''CREATE'',''SYNC'') '||
1696: ' AND process_status = 1'||
1697: ' AND ''F'' = '||
1698: ' ( SELECT item_num_gen_method'||
1699: ' FROM mtl_item_catalog_groups_b '||
1700: ' WHERE NVL(item_num_gen_method,''I'') IN (''U'',''S'', ''F'') '||
1701: ' AND ROWNUM = 1 '||
1702: ' CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID';
1703: IF G_CATALOG_GROUP_ID IS NULL THEN

Line 1730: ' FROM mtl_item_catalog_groups_b '||

1726: ' AND UPPER(ebi.transaction_type) IN (''CREATE'',''SYNC'') '||
1727: ' AND process_status = 1'||
1728: ' AND ''S'' = '||
1729: ' ( SELECT item_num_gen_method'||
1730: ' FROM mtl_item_catalog_groups_b '||
1731: ' WHERE NVL(item_num_gen_method,''I'') IN (''U'',''S'', ''F'') '||
1732: ' AND ROWNUM = 1 '||
1733: ' CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID';
1734: IF G_CATALOG_GROUP_ID IS NULL THEN

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

1848: -- l_dyn_sql := l_dyn_sql || ' SET (MSII.ITEM_CATALOG_GROUP_ID, MSII.PROCESS_FLAG)=';
1849: -- l_dyn_sql := l_dyn_sql || '( ';
1850: -- l_dyn_sql := l_dyn_sql || ' SELECT MICG.ITEM_CATALOG_GROUP_ID ';
1851: -- l_dyn_sql := l_dyn_sql || ' , DECODE(NVL(MICG.ITEM_CATALOG_GROUP_ID, -1), -1,'||G_ITEM_CATALOG_NAME_ERR_STS||', ' || G_PROCESS_STATUS || ' ) ';
1852: -- l_dyn_sql := l_dyn_sql || ' FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG, EGO_BULKLOAD_INTF EBI ';
1853: -- l_dyn_sql := l_dyn_sql || ' WHERE MICG.CONCATENATED_SEGMENTS(+) = EBI.'||l_intf_col_name_tbl(i);
1854: -- l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';
1855: -- l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';
1856: -- ----------------------------------------------------------------------------------

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

3607: l_dyn_sql := ' UPDATE EGO_BULKLOAD_INTF EBI';
3608: l_dyn_sql := l_dyn_sql || ' SET '||G_ITEM_CATALOG_EBI_COL||' = ';
3609: l_dyn_sql := l_dyn_sql || '( ';
3610: l_dyn_sql := l_dyn_sql || ' SELECT TO_CHAR(MICG.ITEM_CATALOG_GROUP_ID) ';
3611: l_dyn_sql := l_dyn_sql || ' FROM MTL_ITEM_CATALOG_GROUPS_B_KFV MICG ';
3612: l_dyn_sql := l_dyn_sql || ' WHERE MICG.CONCATENATED_SEGMENTS = EBI.'||l_item_catalog_name_col;
3613: l_dyn_sql := l_dyn_sql || ') ';
3614: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';
3615: l_dyn_sql := l_dyn_sql || ' AND EBI.'||l_item_catalog_name_col||' IS NOT NULL';