APPS.AHL_PP_MATERIALS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 335: FROM MTL_SYSTEM_ITEMS_KFV

331: IF (p_inventory_item_id IS NOT NULL AND
332: p_inventory_item_id <> FND_API.G_MISS_NUM) THEN
333: --
334: SELECT inventory_item_id INTO x_inventory_item_id
335: FROM MTL_SYSTEM_ITEMS_KFV
336: WHERE inventory_item_id = p_inventory_item_id
337: AND organization_id = p_organization_id
338: AND inventory_item_flag = 'Y'
339: AND stock_enabled_flag = 'Y'

Line 346: FROM MTL_SYSTEM_ITEMS_KFV

342: AND trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and trunc(nvl(end_date_active, sysdate));
343: ELSE
344: --
345: SELECT inventory_item_id INTO x_inventory_item_id
346: FROM MTL_SYSTEM_ITEMS_KFV
347: WHERE concatenated_segments = p_concatenated_segments
348: AND organization_id = p_organization_id
349: AND inventory_item_flag = 'Y'
350: AND stock_enabled_flag = 'Y'

Line 975: FROM mtl_system_items_kfv mtl,

971: ) IS
972: CURSOR Get_rec_from_id (c_inventory_item_id NUMBER, c_item_group_id NUMBER, c_organization_id NUMBER)
973: IS
974: SELECT DISTINCT mtl.inventory_item_id
975: FROM mtl_system_items_kfv mtl,
976: ahl_item_groups_vl aig,
977: ahl_item_associations_b ais
978: WHERE mtl.organization_id = c_organization_id --org.organization_id
979: AND nvl(mtl.enabled_flag,'N') = 'Y'

Line 992: FROM mtl_system_items_kfv mtl,

988: AND mtl.inventory_item_id = c_inventory_item_id;
989: CURSOR Get_rec_from_value (c_concatenated_segments VARCHAR2, c_item_group_id NUMBER, c_organization_id NUMBER)
990: IS
991: SELECT DISTINCT mtl.inventory_item_id
992: FROM mtl_system_items_kfv mtl,
993: ahl_item_groups_vl aig,
994: ahl_item_associations_b ais
995: WHERE mtl.organization_id = c_organization_id --org.organization_id
996: AND nvl(mtl.enabled_flag,'N') = 'Y'

Line 1075: ) MC_REL, AHL_ITEM_GROUPS_VL AIG, MTL_SYSTEM_ITEMS_KFV MSI,

1071: AMR.MC_HEADER_ID = AMCR.MC_HEADER_ID AND
1072: NVL(AMCR.ACTIVE_END_DATE,SYSDATE + 1) > SYSDATE AND
1073: AMR.PARENT_RELATIONSHIP_ID IS NULL AND
1074: AMCR.RELATIONSHIP_ID = c_relationship_id
1075: ) MC_REL, AHL_ITEM_GROUPS_VL AIG, MTL_SYSTEM_ITEMS_KFV MSI,
1076: AHL_ITEM_ASSOCIATIONS_B AIS
1077: WHERE
1078: AIG.STATUS_CODE = 'COMPLETE' AND
1079: MC_REL.ITEM_GROUP_ID = AIG.ITEM_GROUP_ID AND

Line 1110: ) MC_REL, AHL_ITEM_GROUPS_VL AIG, MTL_SYSTEM_ITEMS_KFV MSI,

1106: AMR.MC_HEADER_ID = AMCR.MC_HEADER_ID AND
1107: NVL(AMCR.ACTIVE_END_DATE,SYSDATE + 1) > SYSDATE AND
1108: AMR.PARENT_RELATIONSHIP_ID IS NULL AND
1109: AMCR.RELATIONSHIP_ID = c_relationship_id
1110: ) MC_REL, AHL_ITEM_GROUPS_VL AIG, MTL_SYSTEM_ITEMS_KFV MSI,
1111: AHL_ITEM_ASSOCIATIONS_B AIS
1112: WHERE
1113: AIG.STATUS_CODE = 'COMPLETE' AND
1114: MC_REL.ITEM_GROUP_ID = AIG.ITEM_GROUP_ID AND

Line 4330: FROM mtl_system_items_kfv

4326: CURSOR Get_Item_Name_Cur(c_inventory_item_id IN NUMBER,
4327: c_organization_id IN NUMBER)
4328: IS
4329: SELECT concatenated_segments
4330: FROM mtl_system_items_kfv
4331: WHERE inventory_item_id = c_inventory_item_id
4332: AND organization_id = c_organization_id;
4333:
4334: -- Standard local variable

Line 5188: FROM mtl_system_items_kfv

5184: --
5185: CURSOR Get_item_cur(c_segments IN VARCHAR2)
5186: IS
5187: SELECT distinct(inventory_item_id)
5188: FROM mtl_system_items_kfv
5189: WHERE concatenated_segments = c_segments;
5190: --
5191: l_return VARCHAR2(1);
5192: --

Line 5233: FROM mtl_system_items_kfv

5229: --
5230: CURSOR Get_item_cur(c_segments IN VARCHAR2)
5231: IS
5232: SELECT distinct(inventory_item_id)
5233: FROM mtl_system_items_kfv
5234: WHERE concatenated_segments = c_segments;
5235: --
5236: l_inventory_item_id NUMBER;
5237: l_rt_oper_material_id NUMBER;

Line 6485: FROM mtl_system_items_kfv

6481:
6482: --Cursor to get item name and primary uom code at organization level
6483: CURSOR Get_Item_Uom_Code(c_inventory_item_id NUMBER, c_organization_id NUMBER) IS
6484: SELECT concatenated_segments,primary_uom_code
6485: FROM mtl_system_items_kfv
6486: WHERE inventory_item_id = c_inventory_item_id
6487: AND organization_id = c_organization_id;
6488:
6489: --Cursor to get uc_header_id for workorder

Line 6506: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

6502: l_msg_count NUMBER;
6503: l_return_status VARCHAR2(1);
6504: l_req_ci_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
6505: l_uom_code MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;
6506: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
6507: l_current_mat_dtl_rec Get_WO_Mat_Details%ROWTYPE;
6508: l_uc_header_id NUMBER;
6509:
6510: BEGIN