APPS.GMD_SPEC_GRP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 75: FROM mtl_system_items_kfv

71: -- Bug# 5251612
72: -- Added additional where clause to check process_quality_enabled_flag
73: CURSOR c_item(p_inventory_item_id NUMBER, p_organization_id NUMBER) IS
74: SELECT concatenated_segments,grade_control_flag
75: FROM mtl_system_items_kfv
76: WHERE inventory_item_id = p_inventory_item_id
77: AND organization_id = p_organization_id
78: AND process_quality_enabled_flag = 'Y';
79:

Line 1061: l_item MTL_SYSTEM_ITEMS_KFV%ROWTYPE;

1057: l_specification GMD_SPECIFICATIONS%ROWTYPE;
1058: l_specification_out GMD_SPECIFICATIONS%ROWTYPE;
1059: l_test GMD_QC_TESTS%ROWTYPE;
1060: l_test_out GMD_QC_TESTS%ROWTYPE;
1061: l_item MTL_SYSTEM_ITEMS_KFV%ROWTYPE;
1062: -- Bug 3401368
1063: x_viability_time NUMBER;
1064: x_viability_status varchar2(100);
1065:

Line 1150: -- fields needed from mtl_system_items_kfv

1146: (x_spec_type = 'I') THEN
1147: BEGIN
1148:
1149: -- bug 4924529 sql id 14686748
1150: -- fields needed from mtl_system_items_kfv
1151: -- are l_item.primary_uom_code, l_item.lot_control_code and l_item.concatenated_segments.
1152: -- 155714 memory reduced
1153: -- cost is 3
1154:

Line 1156: -- FROM mtl_system_items_kfv

1152: -- 155714 memory reduced
1153: -- cost is 3
1154:
1155: -- SELECT * INTO l_item
1156: -- FROM mtl_system_items_kfv
1157: -- WHERE organization_id = l_specification.owner_organization_id
1158: -- AND inventory_item_id = l_specification.inventory_item_id;
1159:
1160: SELECT primary_uom_code,

Line 1166: FROM mtl_system_items_kfv

1162: concatenated_segments
1163: INTO l_item.primary_uom_code,
1164: l_item.lot_control_code,
1165: l_item.concatenated_segments
1166: FROM mtl_system_items_kfv
1167: WHERE organization_id = l_specification.owner_organization_id
1168: AND inventory_item_id = l_specification.inventory_item_id;
1169: EXCEPTION WHEN OTHERS
1170: THEN