APPS.GMDRVLAP_WF_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 28: l_item_no MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

24: --Krishna NPD-Conv, Created l_orgn_id, l_item_id. Modified l_orgn_code, l_item_no.
25: l_orgn_id GMD_RECIPE_VALIDITY_RULES.organization_id%TYPE;
26: l_orgn_code ORG_ORGANIZATION_DEFINITIONS.organization_code%TYPE;
27: l_item_id GMD_RECIPE_VALIDITY_RULES.INVENTORY_ITEM_ID%TYPE;
28: l_item_no MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
29: l_preference GMD_RECIPE_VALIDITY_RULES.PREFERENCE%TYPE;
30: l_std_qty VARCHAR2(80);
31: l_min_qty VARCHAR2(80);
32: l_max_qty VARCHAR2(80);

Line 113: FROM GMD_RECIPE_VALIDITY_RULES A, MTL_SYSTEM_ITEMS_KFV B

109: SELECT A.ORGANIZATION_ID,
110: DECODE(A.RECIPE_USE, 0, 'Production', 1, 'Planning', 2, 'Costing', 3, 'Regulatory', 4, 'Technical'),
111: B.CONCATENATED_SEGMENTS, A.PREFERENCE, A.STD_QTY || ' ' || A.DETAIL_UOM, A.MIN_QTY || ' ' || A.DETAIL_UOM, A.MAX_QTY || ' ' || A.DETAIL_UOM, A.START_DATE, A.END_DATE
112: INTO l_orgn_id, l_recipe_use, l_item_no, l_preference, l_std_qty, l_min_qty, l_max_qty, l_effective_start_date, l_effective_end_date
113: FROM GMD_RECIPE_VALIDITY_RULES A, MTL_SYSTEM_ITEMS_KFV B
114: WHERE A.RECIPE_VALIDITY_RULE_ID = P_RECIPE_VALIDITY_RULE_ID
115: AND A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
116: AND A.organization_id = B.organization_id;
117: