DBA Data[Home] [Help]

APPS.AHL_UC_TREE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 394: mtl_system_items_kfv M

390: M.concatenated_segments||'-'||NVL(C.serial_number, C.instance_number) part_info,
391: 'N'
392: FROM csi_ii_relationships R,
393: csi_item_instances C,
394: mtl_system_items_kfv M
395: WHERE R.object_id = c_instance_id
396: AND R.subject_id = C.instance_id
397: AND C.inventory_item_id = M.inventory_item_id
398: AND C.inv_master_organization_id = M.organization_id

Line 625: FROM mtl_system_items_kfv M,

621: FUNCTION part_info(p_instance_id NUMBER) RETURN VARCHAR2 IS
622: l_part_info VARCHAR2(80);
623: CURSOR get_part_info(c_instance_id NUMBER) IS
624: SELECT M.concatenated_segments||'-'||NVL(C.serial_number, C.instance_number) part_info
625: FROM mtl_system_items_kfv M,
626: csi_item_instances C
627: WHERE C.instance_id = c_instance_id
628: AND C.inventory_item_id = M.inventory_item_id
629: AND C.inv_master_organization_id = M.organization_id;