APPS.GMD_SPEC_GRP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 90: FROM mtl_system_items_kfv

86: -- Bug# 5251612
87: -- Added additional where clause to check process_quality_enabled_flag
88: CURSOR c_item(p_inventory_item_id NUMBER, p_organization_id NUMBER) IS
89: SELECT concatenated_segments,grade_control_flag
90: FROM mtl_system_items_kfv
91: WHERE inventory_item_id = p_inventory_item_id
92: AND organization_id = p_organization_id
93: AND process_quality_enabled_flag = 'Y';
94:

Line 1113: l_item MTL_SYSTEM_ITEMS_KFV%ROWTYPE;

1109: l_specification GMD_SPECIFICATIONS%ROWTYPE;
1110: l_specification_out GMD_SPECIFICATIONS%ROWTYPE;
1111: l_test GMD_QC_TESTS%ROWTYPE;
1112: l_test_out GMD_QC_TESTS%ROWTYPE;
1113: l_item MTL_SYSTEM_ITEMS_KFV%ROWTYPE;
1114: -- Bug 3401368
1115: x_viability_time NUMBER;
1116: x_viability_status varchar2(100);
1117:

Line 1202: -- fields needed from mtl_system_items_kfv

1198: (x_spec_type = 'I') THEN
1199: BEGIN
1200:
1201: -- bug 4924529 sql id 14686748
1202: -- fields needed from mtl_system_items_kfv
1203: -- are l_item.primary_uom_code, l_item.lot_control_code and l_item.concatenated_segments.
1204: -- 155714 memory reduced
1205: -- cost is 3
1206:

Line 1208: -- FROM mtl_system_items_kfv

1204: -- 155714 memory reduced
1205: -- cost is 3
1206:
1207: -- SELECT * INTO l_item
1208: -- FROM mtl_system_items_kfv
1209: -- WHERE organization_id = l_specification.owner_organization_id
1210: -- AND inventory_item_id = l_specification.inventory_item_id;
1211:
1212: SELECT primary_uom_code,

Line 1218: FROM mtl_system_items_kfv

1214: concatenated_segments
1215: INTO l_item.primary_uom_code,
1216: l_item.lot_control_code,
1217: l_item.concatenated_segments
1218: FROM mtl_system_items_kfv
1219: WHERE organization_id = l_specification.owner_organization_id
1220: AND inventory_item_id = l_specification.inventory_item_id;
1221: EXCEPTION WHEN OTHERS
1222: THEN