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.GMD_EBI_RECIPE_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 173: SELECT inventory_item_id INTO l_item_id FROM mtl_system_items_kfv

169: l_formula_obj := p_formula_obj;
170: IF l_formula_obj IS NOT NULL THEN
171: FOR j in 1..l_formula_obj.formula_details.COUNT LOOP
172: IF (l_formula_obj.formula_details(j).inventory_item_id IS NULL) THEN
173: SELECT inventory_item_id INTO l_item_id FROM mtl_system_items_kfv
174: WHERE concatenated_segments = l_formula_obj.formula_details(j).item_no
175: AND organization_id = l_formula_obj.formula_details(j).owner_organization_id;
176: l_formula_obj.formula_details(j).inventory_item_id := l_item_id;
177: END IF;

Line 1149: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;

1145: OR l_line_id = p_recipe_obj.formula_obj.formula_details(k).FORMULALINE_ID) THEN
1146: l_org_id := get_org_id(p_recipe_obj.formula_obj.formula_header.OWNER_ORGANIZATION_CODE);
1147: IF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = -1) THEN
1148: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1149: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1150: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1151: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space) ||':'||l_item_desc;
1152: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1153: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;

Line 1157: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;

1153: l_text_ing := l_text_ing || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;
1154: l_text_ing := l_text_ing || l_new_line;
1155: ELSIF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = 1) THEN
1156: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1157: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1158: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1159: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space)||':'||l_item_desc;
1160: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1161: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;

Line 1165: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;

1161: l_text_products := l_text_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;
1162: l_text_products := l_text_products || l_new_line;
1163: ELSIF(p_recipe_obj.formula_obj.formula_details(k).LINE_TYPE = 2) THEN
1164: l_text_by_products := l_text_by_products || l_new_line ||LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_LINE_NUMBER'),17,l_space) ||':'||p_recipe_obj.formula_obj.formula_details(k).LINE_NO ;
1165: SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
1166: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITEMNO'),16,l_space) ||':'||l_item_no;
1167: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_ITMDESC'),23,l_space)||':'||l_item_desc;
1168: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_QUANTITY'),14,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).QTY;
1169: l_text_by_products := l_text_by_products || l_new_line || LPad(FND_MESSAGE.GET_STRING('GMD','GMD_EBI_ATTACHMENT_UOM'),10,l_space)||':'||p_recipe_obj.formula_obj.formula_details(k).DETAIL_UOM;